Hello,
I created a DTS to copy some data from a sql server to another.
I would like to use a global variable on a Transform Data Task with a sql
query like
" SELECT * FROM Table Where Id=? " in order to call the DTS with DtsRun.exe
and put the value of the global variable on the command line.
How can I do ?

thanks

Yes. Create the global variable. Create your Execute SQL task. Type in the
query with the ? parameter place holder, click on the Parameters button and
map the parameter to the global variable. When you run the package from the
command line, use the /A switch to specify your global variable value. Type
dtsrun /? at the command prompt to see the exact syntax.

Charles Kangai, MCT, MCDBA



"Richard Urrutia" wrote: