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