var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: DTSRUN /A Issue
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 -S22.214.171.124 -Usa -Psa -N"Rahul_Test" -ARahul:8="aaa"'
After executing the syntax I am getting the following message...
DTSRun: Package execution complete.
But the global variable "Rahul" doesnot get changed to 225.
Kindly help me out in this regard.
Thanks in advance.
"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 -S126.96.36.199 -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..........