Validation Of For Loop Very Slow On Load

Hi there,

I have recently added a nested for loop into my SSIS package (The 'parent' for loop loops through years with a variable @DAT_YEAR, the 'child' for loop loops through months of those years using @DAT_MONTH). The task contained within the 'child' loop is a data flow transformation which connects to a source ODBC database and writes out data to a text file a month at a time, supplying the @DAT_YEAR and @DAT_MONTH variables as expressions in the SqlCommand statement.

The logic of the data flow seems to work fine, however, I notice that when I load the package now, it seems to take forever (> 5 minutes, certainly) to regain control in Visual Studio, and the status message at the bottom left of the VS window reads "Validating For Loop Container".

I know that you can work in 'offline' mode to temporarily turn off the validation, but I cannot manage any of the connections in this mode - why is it taking so long? Is it actually doing the loop and validating the ODBC connection each iteration?

yours puzzled,

t.