SQL Server Performance Forum – Threads Archive

DTS: advice on dynamically changing destination fi

Env: SQL-Server 2000 on Windows 2000 I have a dts package that exports data to a text file. I use DTSRun utility to execute this package from my stored procedure.
I need to change dynamically destination path for the text file in the package using the /A command switch to allocate and initialize global variables.
Is there a way to do that not using VBScript? thanks
Alex

http://www.databasejournal.com/features/mssql/article.php/1461481 – DTS How to…dynamically change…Connections.
http://www.winnetmag.com/SQLServer/Article/ArticleID/7836/7836.html
http://www.sqldts.com/?200
http://www.sqldts.com/default.aspx?231
http://www.sqldts.com/default.aspx?252 … articles – way to go. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Satya,
Thanks for links.
I used Dynamic Properties Task with global variable in DTS Package.
Alex

]]>