July 16, 2018 at 9:40 am
Hello, I have three steps, that are the same as one another just a different table of focus, a Delete table that connects to a data flow task that runs SQL on Teradata and lands data on local SQL Server. Right now I have that in a Sequence Container. I know that if I didn't have it in the Seq Cont that it would still run in a sequential manner. How can I run this all in parallel, if possible? Thanks
July 16, 2018 at 9:59 am
quinn.jay - Monday, July 16, 2018 9:40 AMHello, I have three steps, that are the same as one another just a different table of focus, a Delete table that connects to a data flow task that runs SQL on Teradata and lands data on local SQL Server. Right now I have that in a Sequence Container. I know that if I didn't have it in the Seq Cont that it would still run in a sequential manner. How can I run this all in parallel, if possible? Thanks
Tasks in SSIS run sequentially, if they are connected by precedence constraints.
If you do not add precedence constraints, the tasks run in parallel.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply