when you run Ssis package through BIDS or SSDT, package variables does get populated from environment variablabe. When it was running uder sql job agent, it failed to read from Env. Variables.
Solution:
1. Restart SQL SERVER AGENT for that instance and Intergration Service Engine
2. Restart SSMS
No comments:
Post a Comment