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 execution latency when assign to a variable
- What is the best way to cache a table from a (SQL)
- php PDO::FETCH_ASSOC doesnt detect select after ba
- Bulk update SQL Server C#
- $ENV{$variable} in perl
相关文章
- How should I configure log4net to write to %LOCALA
- Entity Framework 4.3.1 failing to create (/open) a
- Override env values defined in container spec
- Code for inserting data into SQL Server database u
- SSIS solution on GIT?
- Delete Every Alternate Row in SQL
- Unable to see or modify value of PYTHONHASHSEED th
- Linux based PHP install connecting to MsSQL Server
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.