Overiding variable in SSIS in sql job

Rohit Kochar 6 Reputation points
2021-08-19T01:47:04.13+00:00

hello all,

I have a SSIS package that is deployed to sql server 2016. I run this package through a sql server job. There is a requirement where I want to override the value of that variable when I run the package from sql job. Can someone share an article or help me to achieve this?

Thanks,
Rohit

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,808 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,460 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,558 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 33,296 Reputation points
    2021-08-19T03:09:41.513+00:00

    Hi @Rohit Kochar ,

    Edit the Job step and you should see a tab "Set Values" which can be used to change the value.

    Details you may refer:

    passing-value-into-ssis-from-a-sql-job

    parameterizing-connections-and-values-at-runtime-using-ssis-environment-variables

    Regards，

    Zoe

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October