• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 202
  • Last Modified:

ssis paralel execution

Hello I have a package that has a sql task that queries a look up table and gets the server information , database. I dynamically build the connection string and use a for each container to loop through all the connections. I would like to run this in parallel I added 4 connection managers now I would like to Identify which servers run on what  dataflow via parameter or config file to avoid creating duplicate file. I also cannot make any changes to the source table
1 Solution
Logically a foreach container cannot run in parallel with itself, as a cursor can only be in one place at one time. If there will always be four connections, set them up separately inside a sequence container. This will enable you to assign each its own set of variables and parameters which can be modified by the query step without needing to change any source data.
sql20Author Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now