How can i send a parameter to DTS packege?
For Example, I want to transfer data from SQL Server to text file, But
the name of text file is variable.and i want to send it's name by
parameter, how can i do that?



Thanks
Elham

The normal method would be to use a global variable to hold the filename.
Inside the package use the Dynamic Properties task set the filename on the
connection from the global variable value.

Setting the global variable when executing the package will vary depend on
how you want to execute the package, but one of the most common methods is
to use the /A parameter on the DTSRUN command.


--
Darren Green
http://www.sqldts.com



"Elham GH" <ElhamGh_TechMail (AT) yahoo (DOT) com> wrote