Very good tip on setting package variables from SQL Jobs:
SSIS Tip #1: Set SSIS package variables via SQL Agent jobs - Steve Holstad's "the bright lights"
This is an OK article. I am still figuring out how to use a DateTime Variable as a parameter in an Execute SQL Task:
Working with Parameters and Return Codes in the Execute SQL Task
Will post a solution later...
![](http://img.zemanta.com/pixy.gif?x-id=e919d4e8-2d3c-4344-ab88-4cb54f3c1cc1)
SSIS Tip #1: Set SSIS package variables via SQL Agent jobs - Steve Holstad's "the bright lights"
This is an OK article. I am still figuring out how to use a DateTime Variable as a parameter in an Execute SQL Task:
Working with Parameters and Return Codes in the Execute SQL Task
Will post a solution later...
![](http://img.zemanta.com/pixy.gif?x-id=e919d4e8-2d3c-4344-ab88-4cb54f3c1cc1)