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 variable to specify a connection, or any other parameter or property, in a loop, the variable must be initialized prior to execution of the loop.
Solution:
To resolve this error, provide an initial value for the variable you are using in your expression (e.g. for the server host in this example).
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
Related Articles
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 ...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.Error Message: Invalid Server Host (Salesforce Connection)
Action: When using the Salesforce Connection I am getting the error message below: Error Message: "Invalid Server Host" Solution: Salesforce has sent out notices to their customers that some Salesforce Platform API legacy versions will be deprecated ...Error Message: An existing connection was forcibly closed by the remote host
Action When making a request to a service connection, the following error message was returned. Error Message Error Message: An existing connection was forcibly closed by the remote host Solution The error message can be somewhat generic across ...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 ...