db_guy


Hi All,

I wanna know if we can have more than one "OLEDB Destination" within a Data Flow Task, I want to use the same data flow and write to two different tables in a database with some changes. If we cannot do this within the same data flow what is the best way to do this.

Thanks




Re: Two Destinations in a Data Flow Task

PedroCGD


Yes.

You need to add a Multicast Transform to your dataflow and add the 2 OLEDB Destinations and link the Multicast to each of them.

Helped

regards!







Re: Two Destinations in a Data Flow Task

Karunakaran

You should be able to do that with Multicast Transformation.

Be sure to check this post
http://blogs.conchango.com/jamiethomson/archive/2006/07/10/SSIS_3A00_-MULTICAST-bug.aspx

Thanks