Lets say I have 10 tasks in the data flow, but I want to execute only 5 tasks which don't depend on any other tasks in that data flow.
I don't want to execute all my tasks all the time while I am in development stage. Is it possible to execute that way? How can I do that?
You can't put tasks into a data-flow so do you mean:
-Tasks in the control-flow
or
-Components in a data-flow
?
-Jamie|||Sorry for the confusion. Components in a data flow task.
So I have a data flow task created in Control flow and then I have
10 components (OLE DB Src and OLE DB dest connections) that extracts data and loads data in the Data Flow. I want to execute 2 out of those 10 to load my new 2 tables.
|||You can't stop tasks running in a dataflow. You can only limit how many sources are processing at the same time. So if you had 10 sources and only wanted 2 at a time you could set the EngineThreads property to 2 and only 2 would be going at any one time but all would get executed before the dataflow completed. If you don't want this then you would need to create separate dataflows for the ones you want to run together and then disable the dataflows you didn't want to run.
HTH,
Matt
No comments:
Post a Comment