Check this where in the first example arshad has used multicast to create 2 copies of the data set and then load them onto two different destinations. You would do the same except that you will not map all the columns in both the destinations. Instead one destinations maps column 1,2 and the other maps column 3,4 only.http://btsbee.wordpress.com/

Hi Stephen, Use Conditional Split task in Data Flow Transformations. Give the conditions accordingly and split data to different flatfiles. Regards, Sathya http://sathyadb.blogspot.in/sathyas

Hi Stephen, Use Conditional Split task in Data Flow Transformations. Give the conditions accordingly and split data to different flatfiles. Regards, Sathya http://sathyadb.blogspot.in/ sathyas Wrong. He wants the same data in both files thus Conditional Split won't work.ObjectStorageHelper<T> A WinRT utility for Windows 8 | http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me

Hi All, Multicast is exactly the one I looking for, problem solved, many thanks! Regards stephen

Hi, A qick question for the data flow: How to output table to two different flatfile ? For example, we got Table A contains column 1, column2, column 3 and column 4. I want to output column 1 and Column 2 to Flatfile B and Column 3 and column 4 to flatfile C. It should be noted that Table A is generated from the previous data flow and currently not stored in the SQL Server. Can someone tell me which tools I should use in SSIS to seperate the data into 2 flatfiles? Many thanks Best Regards Stephen

Hi Stephen, Use the Multicast component. regards JamieObjectStorageHelper<T> A WinRT utility for Windows 8 | http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me

I agree with Jamie.Multicast would be helpful to achieve the expected output. Thanks, Abhiyanta

Check this where in the first example arshad has used multicast to create 2 copies of the data set and then load them onto two different destinations. You would do the same except that you will not map all the columns in both the destinations. Instead one destinations maps column 1,2 and the other maps column 3,4 only.http://btsbee.wordpress.com/