InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 22:24:24 GMT20http://www.sqlservercentral.com/Forums/Topic1404835-364-1.aspxOne possible reason why there are no rows going into the second table is that you have the multicast in the wrong place. The multicast needs to happen [b]before[/b] the write to the first table. You can think of it as creating an identical copy of every row that comes into the multicast. Then the two results of the multicast go to the first and the second table (one each).Another possible reason why there are no rows being inserted into the second table is that there is something wrong with the insert (permissions or missing fields or incorrect fields or the like). However, you should see errors if that were the case.Fri, 11 Jan 2013 12:25:26 GMTBruce W Cassidyhttp://www.sqlservercentral.com/Forums/Topic1404835-364-1.aspxFiles?You mentioned only one in your first post.Thu, 10 Jan 2013 04:24:12 GMTPhil Parkinhttp://www.sqlservercentral.com/Forums/Topic1404835-364-1.aspxThe package has pushed files to the first table but has written 0 files to the second table.Thu, 10 Jan 2013 04:22:29 GMTdbmanhttp://www.sqlservercentral.com/Forums/Topic1404835-364-1.aspx[quote][b]ziako (1/10/2013)[/b][hr]Hi I tried both methods but 0 rows were written to the OLE DB Destination 1 (new table).Is there something I am missing?[/quote]Are you saying that it previously wrote many rows, you added a multicast and now it writes zero?Thu, 10 Jan 2013 03:51:55 GMTPhil Parkinhttp://www.sqlservercentral.com/Forums/Topic1404835-364-1.aspxHi I tried both methods but 0 rows were written to the OLE DB Destination 1 (new table).Is there something I am missing?Thu, 10 Jan 2013 03:35:27 GMTdbmanhttp://www.sqlservercentral.com/Forums/Topic1404835-364-1.aspxThats one to investigate, never used multicast.Wed, 09 Jan 2013 08:47:55 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1404835-364-1.aspxYes.In the data flow, after the data source, add a MULTICAST.Connect one MULTICAST output to the existing table and another to the new table.Wed, 09 Jan 2013 08:47:07 GMTPhil Parkinhttp://www.sqlservercentral.com/Forums/Topic1404835-364-1.aspxWithin the same DFT, just drag in another flat file source and another destination and mapp the two.So 2 Flat File Sources, pointing to the same Flat File Connection Manager, 1 OLE DB Destination to DB1, 1 OLE DB Destination to DB2.Wed, 09 Jan 2013 08:46:23 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1404835-364-1.aspxI have one flat file that i import into a table using an SSIS package. In BIDS i have a data flow task with Flat File pointing to OLE DB Destination.I have another table in Database that i need to import the same file. Is there a way to do this using the same SSIS package, rather than creating another package?ThanksWed, 09 Jan 2013 08:40:12 GMTdbman