How to set up a dynamic loop connection
Follow the steps below to set up a dynamic iteration-variable dependent connection:
- Create a variable with the package scope and use this variable in the connection manager to construct your expression.
- Create a new variable with the same name and type, but with the loop scope.
The Parallel Loop Task will use the variable with the loop scope to evaluate the connection manager expression and build the dynamic connection.
Starting with SSIS+ 1.7 SR-1 you should no longer create a variable with the same name in the loop scope.