Hi,
I have a DTS named "Rahul_Test" where i have a global variale named "Rahul" INteher (1 Byte). N trying to assign this variable from SQL statement. Here is the syntax that I am writing.
exec master..xp_cmdshell 'DTSRUN -E -S142.102.27.222 -Usa -Psa -N"Rahul_Test" -ARahul:8="aaa"'
After executing the syntax I am getting the following message...
DTSRun: Loading...
DTSRun: Executing...
DTSRun: Package execution complete.
NULL
But the global variable "Rahul" doesnot get changed to 225.
Kindly help me out in this regard.
Thanks in advance.
Rahul Jhaone qn,
"Rahul" is integer or string data type?|||Rahul is a string data type|||Have tried even with this syntax....... still it failed with the same output
exec master..xp_cmdshell 'DTSRUN -E -S142.102.27.222 -Usa -Psa -N"Rahul_Test" -A"Rahul:8"="225"'|||Rahul is String Data Type. By Mistake it was written as Integer while posting the issue........
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment