Post reply

Feed SSIS variables from SQL job

  • November 10, 2009 at 9:54 am

    #142980

    Hi all,

    I have a SSIS package which has been deployed to a server. It has 5 variables. I have a SQL Server job which is set on a schedule to run the package. It looks like the job is running the package, but the package always runs the default values I have have the variables set as. I am unsure how to feed the 5 SSIS variables from the job when it runs. Can someone direct me as to how I'd go about doing this?

    Thanks,

    Strick

  • November 11, 2009 at 10:43 am

    #1077938

    stricknyn (11/10/2009)

    Hi all,

    I have a SSIS package which has been deployed to a server. It has 5 variables. I have a SQL Server job which is set on a schedule to run the package. It looks like the job is running the package, but the package always runs the default values I have have the variables set as. I am unsure how to feed the 5 SSIS variables from the job when it runs. Can someone direct me as to how I'd go about doing this?

    Thanks,

    Strick

    You have to use /SET option on the command line. Check dtexec documentation for more information.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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

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