How to Output one single table to two different flatfile?

Question

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 

Answer 1

Hi Stephen,

Use the Multicast component.

regards
Jamie

---

ObjectStorageHelper<T> – A WinRT utility for Windows 8 | http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me

Answer 2

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

Thanks,

Abhiyanta

Answer 3

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/

Answer 4

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

Answer 5

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

Answer 6

Hi All,

  Multicast is exactly the one I looking for, problem solved, many thanks!

Regards

stephen