Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 DTS remote destination file

Author  Topic 

ahmadsalem
Starting Member

2 Posts

Posted - 2007-08-26 : 14:23:13
I am creating a DTS package that copies data from a table to a text file. I run this package through a VB.Net application. I want the generated text file to be created on the local machine of the user running the application. That means that User A will have the file created on his machine, User B will have the file created on his machine and so on.....How could I perform this ?

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-26 : 18:13:12
Use global parameter for file location.
Go to Top of Page

ahmadsalem
Starting Member

2 Posts

Posted - 2007-08-27 : 01:35:07
how could I do this ? could you give me more details please..
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-27 : 22:11:51
Check books online for details, and you may find samples in dts.com.
Go to Top of Page
   

- Advertisement -