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.

But the global variable "Rahul" doesnot get changed to 225.

Kindly help me out in this regard.

Thanks in advance.

Rahul Jha