July 23, 2007 at 9:05 am
I have two DataReader Sources that export to two seperate text files. Each DataReader Source / Text File Destination combination has its own Data Flow Task e.g. Data Flow Task 1 = DataReader Source A and Text File Destination A, Data Flow Task 2 = DataReader Source B and Text File Destination B
What I want to do is execute Data Flow Task A first then execute Data Flow Task B. After both have successfully completed I want to merge the two Text files.
Can this be done?
July 24, 2007 at 2:05 am
you could use a execute process task and merge using dos but that seems like a bad way to do it.
Why do you want to do this anyway? Can you not have two sources in on DF and using a union all, do it in one go?
You can also write both DF's to a raw file, appending, and have a 3rd DF that dumps the raw file to text.
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
July 24, 2007 at 2:56 am
Hi Crispin,
I did as you suggested, I created two DF and merged them all in one go. Don't know why I didn't think of that to start with but thank you for your help.
April 8, 2008 at 9:51 am
You may actually want to consider doing all this in 1 data flow task. Doing this will do it all in one pop. You wouldn't even have to create two files because SSIS would handle that as well. Just have 1 data flow task, then inside that data flow task you have your two souce connections and one destination connection. Prior to the destination connection you can use the Union All task to combine the results of both source files and output only 1 result.
Strick
April 8, 2008 at 11:00 am
hi david ..could plz explain me or attach a screen shot of ur DF u created so that i can understand easily ...thkz in advance
Thanks,
Chinna
Its the Journey which gives you Happiness not the Destination-- Dan Millman
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply