Re-direct copy of data into multiple data flow
Hi,
I have a business requirement where input data will flow into either Data Flow:A or Data Flow:B. There are few rows, which should flow into both Data Flow:A and Data Flow:B. How can I achieve this in SSIS. Thanks for your help.
October 16th, 2012 5:10am
Hello Tech_Consultant,
This can be achived by Condition split transformation with in the Data Flow. Please refer the below link for more details
http://msdn.microsoft.com/en-us/library/ms137886(v=sql.105).aspxBest Regards Sorna
Free Windows Admin Tool Kit Click here and download it now
October 16th, 2012 5:17am
Thanks for your response. In a conditional split, I can send rows into either one of the data flow. How can I send some of the rows into both the condition?
If Order 3 satisfies, I want the rows to go into both Order 1 and Order 2.
October 16th, 2012 5:31am
Hello Tech_Consultant ,
You can use expression with AND OR condition also. Check for the required symbols under Operators shown in the above screen shot. For Example below is the AND condition
ErrorFlag == 1 && ErrorFlag == 0
Best Regards Sorna
Free Windows Admin Tool Kit Click here and download it now
October 16th, 2012 5:37am
The main problem with using a Conditional split is that the rows can only be directed along one data flow. You actually need two conditional splits and two union alls and a multi cast.
Russel Loski, MCT, MCITP Business Intelligence Developer and Database Developer 2008 Blog: http://www.bidn.com/blogs/RussLoski/ Twitter: @sqlmovers
October 16th, 2012 5:38am
@Russ,
Thanks for your response.
I have a scenario where I have to write warning log as well as error log for input data. However, data with warning should be processed. I do have a data update component and only no-error rows are processed. How can I process the rows with warning
as well as write the rows with warning into a log file. I could not relate this scenario with the above mentioned diagram.
Rows with warning should go into both --> to write a log file and --> to update database.
Free Windows Admin Tool Kit Click here and download it now
October 16th, 2012 6:13am
Using the flow I propose. The first conditional split directs to the Multicast based on the warningflag == TRUE. The default on that conditional split directs to the second conditional split. That second split uses ErrorFlag == 1 and
ErrorFlag == 0.Russel Loski, MCT, MCITP Business Intelligence Developer and Database Developer 2008 Blog: http://www.bidn.com/blogs/RussLoski/ Twitter: @sqlmovers
October 16th, 2012 6:26am
Let's assume Union of Path A -->update the data
Union all path B -->Write rows into log file.
Now, how can I write the row into log file for those rows with warning but no error. ( these row will go through path A)?
Free Windows Admin Tool Kit Click here and download it now
October 16th, 2012 6:34am
Slight change in my answer. You can do this with one conditional.
Russel Loski, MCT, MCITP Business Intelligence Developer and Database Developer 2008 Blog: http://www.bidn.com/blogs/RussLoski/ Twitter: @sqlmovers
October 16th, 2012 12:08pm
Slight change in my answer. You can do this with one conditional.
Russel Loski, MCT, MCITP Business Intelligence Developer and Database Developer 2008 Blog: http://www.bidn.com/blogs/RussLoski/ Twitter: @sqlmovers
Free Windows Admin Tool Kit Click here and download it now
October 16th, 2012 12:28pm