Post reply

How do we pass parameters from Sql agent job to SSIS package?

  • October 2, 2008 at 10:55 pm

    #126624

    Hi ,

    Is there any mechanism to pass parameters inside SSIS package from Sql server agent job?

    Thanks

    Sajesh

  • October 3, 2008 at 4:40 am

    #880370

    There are two ways:

    1. Use the Set values tab in the job step. The property path needs to be \Package.Variables[i]myvariable[/i].Value and then enter the new parameter value in the field on the right

    2. Use the command line tab to run the package, which allows you to set the parameters for the dtexec utility. The switch format is /set \package.variables[i]myvariable[/i].Value;myvalue

    You can see more information on the dtexec utility here

    tom

    Life: it twists and turns like a twisty turny thing

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

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