SSIS package SQL job not using new environment var

2019-09-12 01:27发布

When I set up my Production SQL job to execute my SSIS package which use an environment variable for configuration, the job does not use the Production config value of the environment variable on the production server. The job use the design time values instead. I created the environment variable on the same server that I exec the job (Production). Any thought?

1条回答
三岁会撩人
2楼-- · 2019-09-12 01:38

I figured out that I have to restart the SQL Server Agent in order for the SQL Agent to recognize the newly created Environement Variable.

查看更多
登录 后发表回答