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?
当我设置我的生产SQL作业以执行使用环境变量进行配置的SSIS包时,作业不使用生产服务器上环境变量的生产配置值。该作业使用设计时间值。我在执行作业(生产)的同一台服务器上创建了环境变量。任何想法?
1 个解决方案
#1
1
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.
我发现我必须重新启动SQL Server代理才能让SQL代理识别新创建的Environement Variable。
#1
1
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.
我发现我必须重新启动SQL Server代理才能让SQL代理识别新创建的Environement Variable。