asked
SSIS Variables in For Loop
I am trying to run a discrete extract for six consecutive months. I have set a Global variable @[User::startDate] at the package level. I have Configured the for loop as follows: InitExpression = @[User::startDate]=DateAdd("MM", -9, GETDATE()) EvalExpression = @[User::startDate]
OK - it seems it was the Activ X script causing the problem All fixed now Thanks folks
Can you please add more details? It could help any other user's cause in future. Thanks.
Can you please give more details about your package? Is the variable made available to the Script Task either as ReadOnly or ReadWrite? If there are check points enabled, have you tried deleting the checkpoint file? Are there any parallel components running and trying to work on this variable?
Hi - it's very early days yet. Eventually the for loop container will have a number of datapumps, sql srcipts and procs for validation and manipulation, but at this stage I simply have a
VB.net script which should pop up a message box with the startDate in it.. . . . but it won't even do that yet. No check points or debug breaks as yet.
If you are accessing the StartDate in the script, then try replacing it with a hard-coded string. If possible, share the script with us.
And please make sure that you are making the variable available to the script task either as readonly OR ReadWrite. Otherwise, it will give the same error.
3 People are following this question.
