using global variable

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:

> 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
>
>
>
>
>
>