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 performance, you might want to consider using COZYROC’s more advanced Parallel Loop Task, which can execute multiple iterations of the standard Foreach Loop Container concurrently. Based on actual tests, when a CPU-intensive process is run on a 4-core machine using this Parallel Loop Task, it executes 3 times faster as compared to running the same process sequentially.
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
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 ...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 ...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.Is there a way to set the parameters of a Javascript dynamically when using Javascript Task.
When using JavaScript Task, sometime you create parameters in your JavaScripts, like you see here in the screen capture. You may want to set their values dynamically using variables in the variables window. From the documentation: Under the hood, in ...How to dynamically set the ExcelFilePath when looping through different excel files in a data flow.
Scenario: I have many Excel files with a same format to convert to text files, and I have created a ForEach Loop to loop through each Excel file to have a data flow with an excel source to flat file. Question: How can I dynamically set the ...