Scenario: Deploying SSIS packages that use environment variables and setting up a SQL Server scheduled task to kick them off.
Symptom: Can run packages manually, but the scheduled task fails.
Cause: Environment variables. You have probably logged off and on to the server a few times while attempting to run the packages manually, which means your login has the latest environment variables. However the SQL Server Agent may not have "logged in" recently and will be unaware of the new environment variables.
Resolution: Restart the SQL Server Agent (which is the equivalent of logging it back on to pick up the latest environment variables).
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment