SSIS Task Variables

In some current Testing I am doing work with SSIS.  One task imports data into a database that we baseline for future Test Cases, but to get the data in I need to modify some of the dates.  With SSIS there is an option to adjust data using Derived Columns, with that it's possible to adjust data using Task Scoped Variables; I'll have to find a reference but using project scoped variables did not work initially.

Basically the variables were created this way:

1. Gave a descriptive name (need to have those so you know what to look for later!)
2. Scope, was selected to be the Task being worked on, which was easy since the project only had one task for data loading.
3. Data Type, since it was for Dates I made this DateTime
4. Value, just hit enter/return here and it took the current date and time
5. Expression, this is the real work here
1. For Now this was just left as the default - GetDate()
2. For a Year I made an expression - DATEADD("Year",1,(GetDate()))
3. Same adjustments for Adding Minute or Month, just adjust Year

When using these, in the Derived Columns select the Expression column and in the upper right panel there is a tree for Variables and Parameters.  Select the User: and this will update the value for that column when the Derived Columns task runs.

Learning about DateAdd came from the Microsoft Site