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.

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

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.

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

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

@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.

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

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)?

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

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