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.
Book a Presales Call
Are you new to COZYROC and evaluating our solutions?
Book a Presales Call with us now and get 5% off SSIS+.
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
Considerations about Foreach Loop iteration variable
It is mandatory to use an iteration variable scoped inside the loop container. Failure to do this will result in errors and/or concurrency issues.Where can I find the documentation for the Parallel Loop Task?
You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page. Specific documentation for the Parallel Loop Task can be found at the following link. For many of the components you can find ...My Parallel Loop Task just stopped working.
The Parallel Loop Task may stop working if SQL Server SP is installed on the machine. Therefore it is mandatory the SSIS+ library is reinstalled after SQL Server update.While dynamically changing a connection using variables and expressions inside a Foreach Loop, my source component doesn’t return any data.
Action: While dynamically changing a connection using variables and expressions inside a Foreach Loop, my source component doesn’t return any data. Solution: Be sure to set RetainSameConnection=False in your connection. Ideas: For scalability and ...Error Message: "Invalid ..." or "Invalid Server Host"
Action: While dynamically changing a connection at run-time using expressions and variables in a ForEach Loop, the following error message is encountered. Error Message: "Invalid ..." Example: "Invalid server host". When using an expression and a ...