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
If your using the catalog the preferred way is to look at SSIS Environments and crate the right environment with the right variable options
Alternatively in catalog or package deployment you can override variables at the job level, one of the tabs on the job step will allow you to change variable values.
17 People are following this question.
