May 1, 2007 at 7:42 am
I have 4 datapumps (I'm not sure if its still called this in SSIS) in one data flow task all of them move 24 rows or less. I just got a deadlock error for one of them because 2 of my datapumps blocked each other.
Is there a way to control which of the 4 datapumps gets executed first within one data flow task? Or is the only way to control this to put each datapump in its own data flow task?
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems
May 1, 2007 at 10:33 am
Well I guess here I am answering my own question.
I read in the SQL Tutorial that the execution sequence for mulitple data flows (I previously called it data pump) inside one data flow task is determined by the data flow engine and so if a person wants to control the sequence for multiple data flows then each one must be put in its own data flow task.
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems
February 7, 2012 at 12:57 pm
What about using presidence constraints?
Ian Cockcroft
MCITP BI Specialist
February 7, 2012 at 1:04 pm
I guess the OP is trying to know what is the best possible way to achieve this.
The only way I am aware is to have 4 data flow tasks and have them executed one after the other using precedence constraints..
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
February 10, 2012 at 1:12 pm
The question referred to the the Data Flow. There's no precedence constraints in the data flows.
Executing these as separate data flows would allow to run use precedence constraints to solve the problem.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply