Hi,
I'm writing a stored procedure to run a dts package and I've successfuly
got this working using my sotred proc and the syntax of dtsrun is
correct.
However, I'm trying to pass a variable to the DTSrun command and this is
where I'm having the problem
the code for the proc is:
Declare @partcode nvarchar(255)
EXEC master..xp_cmdshell 'DTSRun /S "server" /U "user" /P "password" /N
"XMLStockCheck" /A "oPartCode":"8"="' + @partcode + '" /W "0" '
Everytime I run it I get this error:
Server: Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near '+'.
can someone help me with this please?
M3ckon
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!