DTS Global variable

[fmt]

Hello,
I have a stotred procedure which grabs the parameter value from a table in a loop. I need to execute dts package and pass this parameter to it. I created a global variable and used the following sql statement

declare @run_me varchar(1000)
set @run_me = 'dtsrun /S devsql2k /U doctracking /P logjam /N agingreporttest /A "processingcenter:8=riverview1"'

EXEC devsql2k.master..xp_cmdshell @run_me


What am I doing wrong. How does DTS assign the parameter value to its global variable?

I am using SQL 2000.

Thanks

 

[Meleagant]

You may have your 'dtsrun....' syntax wrong. Try using the dtsrunui.exe utility. From the Run menu type in dtsrunui and generate your string that way.

Also try with quotes:

set @run_me = 'dtsrun /S "devsql2k" /U "doctracking" /P "logjam" /N "agingreporttest" /A "processingcenter":"8"="riverview1"'

Journeyman -- The Order of the Seekers of Truth and Penitence