Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
allan8964
Posting Yak Master
249 Posts |
 Posted - 2011-11-20 : 10:48:04
|
| Hi there,I tried to import 2 text files to the tables and I set up them in 2 data flows. I noticed that when I run SSIS they are imported at the same time. How can I make them executed separately? I mean when I run text file2 with text file1 not imported. Thanks in advance. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-20 : 10:57:49
|
| ok. if you want them to be executed in sequence join the two data flows using a precedence constraint from your first data flow to second data flow in the order you want. and set an appropriate constraint for precedence like on completion ie second data flow should execute regardless of result of first data flow or on success ie execute second data flow only when first data flow is success------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
allan8964
Posting Yak Master
249 Posts |
Posted - 2011-11-20 : 12:09:38
|
| Thanks visakh16. Could you tell me how to set precedence constraint? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-20 : 13:13:10
|
| select first data flow task in control flow tab. one green arrow will come on bottom. select and stretch it join to next data flow to set precedence constraint. double click on line to open precendence constraint window and select a suitable option ( success, completion etc)------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
allan8964
Posting Yak Master
249 Posts |
Posted - 2011-11-27 : 22:16:40
|
| Got it. Thanks a lot. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-28 : 03:15:51
|
| wc------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Separate the data flow execution