Can I initialize two variables in an SSIS For Loop Container?

Is there any way to initialize the value of two variables in the InitExpression of a For Loop Container in SSIS?

For example:

InitExpression:   @BeginDate = (DT_DBTIMESTAMP) "1/1/1900"; @EndDate = (DT_DBTIMESTAMP) "1/1/2007"
EvalExpression:   @BeginDate < GETDATE()
AssignExpression: @BeginDate = @EndDate; @EndDate = DATEADD("Month", 1, @EndDate)

Thanks

Answers


I don't believe that is possible. However, you could set the @EndDate variable definition as an expression and make it do these calculations in the expression. The For Loop Container would only increment the @BeginDate and the @EndDate would change as it changes.


Need Your Help

How to make grunt watch and grunt nodemon work together

node.js gruntjs grunt-contrib-watch

I have a web app in node.js that I want to start with nodemon, so everytime the main script changes, the webapp can start again.

Access Jquery-UI draggable events from custom function

jquery jquery-ui function jquery-ui-draggable

Heres my custom function called "doIt" which as im sure you can see simply allows someone to call .doIt() on a class or id and in this case makes the background color red and then makes the element