I had this question after viewing Dynamic Database connection in SSIS 2012
I'm using property expressions for servername and database name in the connection that get passed via environment variables. as Megan suggested in her post. However, when I run the package it works perfectly fine from VS 2012, but when I run via SQL Agent/Control-M job, it does not do anything. The job says success, but none of the tables got loaded. I'm doing changing anything such as Integrated security and other properties.
A few suggested script task, but I'm really not aware of how that works as well.
It's a bit urgent!
Greatly Appreciate your help!