Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > VB How-To
|
VB How-To Ask your "How do I do this with VB?" questions in this forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB How-To section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 14th, 2003, 07:02 AM
Registered User
 
Join Date: Oct 2003
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to yogesht194 Send a message via Yahoo to yogesht194
Default sql7 How can I change the fname for a textfile DTS

Sub : In sql server 7 How can I change the filename for a text file connection of DTS

I have DTS stored in Sql server 7. Which i am calling from VB 6.DTS is for exporting records from VIEW to CSV file
Its working file.Now i want to keep the txt file name & path dynamic
So that i can pass this 2 variables to my DTS & dts will store that file on specified locations

Thare are lot of examples fiven on net for sql 2000 by using by dynamic properties like "DTSGlobalVariables("SourceFileName").Value" It works only on SQL 2000
but i want it to do the same with SQL 7

Can somebody put some light on it ?


Cheers,
Yogesh Thavare
Remember, I am not miles away but just a mail away





Similar Threads
Thread Thread Starter Forum Replies Last Post
How to load multiple textfile royaloba Pro VB 6 2 October 27th, 2006 12:18 AM
Change File in DTS? brendalisalowe Pro VB Databases 1 June 24th, 2005 04:55 PM
Executing a DTS package on value change gyno.bell SQL Server DTS 1 March 1st, 2005 02:50 PM
Appending to a TextFile jfleming SQL Server DTS 3 June 16th, 2004 08:45 AM
Importing a TextFile, best way ioates SQL Server 2000 1 June 27th, 2003 07:24 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.