Results 1 to 5 of 5

Thread: DTSRUN /A Issue

  1. #1
    Join Date
    May 2004
    Location
    bangalore
    Posts
    270

    Unanswered: DTSRUN /A Issue

    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 Jha

  2. #2
    Join Date
    Feb 2004
    Location
    Bangalore, India
    Posts
    250
    one qn,

    "Rahul" is integer or string data type?
    Cheers....

    baburajv

  3. #3
    Join Date
    May 2004
    Location
    bangalore
    Posts
    270
    Rahul is a string data type

  4. #4
    Join Date
    May 2004
    Location
    bangalore
    Posts
    270
    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"'

  5. #5
    Join Date
    May 2004
    Location
    bangalore
    Posts
    270
    Rahul is String Data Type. By Mistake it was written as Integer while posting the issue..........

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •