pass dynamic value to ssis package

[scottcabral1979]

I have an SSIS package that has a variable called @RUN_DATE.

I would like to create a sql agent job and uses the set values tab to pass a dynamic parameter to the ssis package.

for example, i would like to always set the variable to the last day of the previous month. I know that If i hardcode the date as 5-31-2013 it works fine, but i have not been able to figure out how to make the value dynamic by using an expression or if this is even possible.

any help would be appreciated.

thanks
Scott

 

[jjefferson]

Rather than try to have the SQL Agent pass a paramter, perhaps you could add either an Execute SQL Task to your package and have it use:

SELECT DATEADD(MS, -3, DATEADD(MM, DATEDIFF(MM, 0, GETDATE()), 0))

to populate your run date with the last day of the previous month, or use a Script Task to have VB/C# do a similar thing to load the variable with the desired date.

Hope I have understood your requirement properly.

Jim