question

RohitKochar-0752 avatar image
0 Votes"
RohitKochar-0752 asked ZoeHui-MSFT commented

Overiding variable in SSIS in sql job

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-generalsql-server-transact-sqlsql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered ZoeHui-MSFT commented

Hi @RohitKochar-0752,

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


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Do you have further question on this , could we offer more support?
If this helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)

0 Votes 0 ·