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)
 Change file name

Author  Topic 

daviddeldave
Starting Member

28 Posts

Posted - 2003-04-23 : 06:48:27
Using ver 7 I want to access a current package and change the name of the destination text file dynamically.

My actual problem is slightly more complicated but if I can do this then I will be well on the way to sorting my issues.

i am very new to dts can anyone help me. i have done research on this but still have not found how to do this.

Many thanks
David

David Mercer

Andraax
Aged Yak Warrior

790 Posts

Posted - 2003-04-23 : 07:10:48
Using version 7, you will have to use an Active Script Task or run the package using VB, and code it yourself. In 2000 there is a task called Dynamic Properties, which does what you want.

Go to Top of Page
   

- Advertisement -