Post reply

Pass value to package scope variable thru job

  • October 20, 2008 at 3:52 pm

    #126125

    Hi all ,,,

    I need to use dtexec to execute my job and need to pass a variable to the package...I am using this command but it's giving me an error that

    Could not set package variable ddate to value '01/01/1900'

    Dtexec /f "C:\Documents and Settings\chibp\testEMP.dtsx" /set \Package.Variable[User::ddate].Properties[Value];"01/01/1900"

    Any thing wrong in my command to set value for a package level variable date..

    Any help?

    thanks

    [font="Comic Sans MS"]
    ---------------------------------------------------

    Thanks [/font]

  • October 20, 2008 at 5:47 pm

    #887373

    SSIS Fresher (10/20/2008)

    Hi all ,,,

    I need to use dtexec to execute my job and need to pass a variable to the package...I am using this command but it's giving me an error that

    Could not set package variable ddate to value '01/01/1900'

    Dtexec /f "C:\Documents and Settings\chibp\testEMP.dtsx" /set \Package.Variable[User::ddate].Properties[Value];"01/01/1900"

    Any thing wrong in my command to set value for a package level variable date..

    Any help?

    thanks

    Possibly the use of double quotes for the value?

    It may be that DTEXEC behaves differently when running the package from file (or even a package in File System).

    My solution (posted under your other thread - Passing parameters to job) works well with 'dtexec /SQL ' - of course, the package must be installed in the MSDB.

    It takes a vastly different number and type of parameters this way, which are either not valid or not working when running from the file system.

    HTH

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply