InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 00:17:08 GMT20http://www.sqlservercentral.com/Forums/Topic1369163-364-1.aspxYou can also use a multicast to direct the recordset to multiple Destination objects in one Data Flow.Mon, 08 Oct 2012 07:17:45 GMTThomas LeBlanchttp://www.sqlservercentral.com/Forums/Topic1369163-364-1.aspxthanks very much for the replies guysill look into both methodsMon, 08 Oct 2012 02:48:38 GMTerics44http://www.sqlservercentral.com/Forums/Topic1369163-364-1.aspxYou might want to look into the use of .RAW files in SSIS. They're basically SSIS's version of temp tables. What they do is pull off a single system into a file (local to the SSIS server is best) in a high-speed access version of the data (you won't be able to read it directly).That raw can then be manipulated repeatedly. My personal use for it is usually when dealing with multiple warehouses, where I need to do heavy transforms and then port the results to multiple targets. First I'll do all the transforms into the raw, and then start pumping it out to the target systems. The reason for this is so I can checkpoint the transformation, keeping me from having to hit the source system more than once in case of a connection failure or somesuch.Fri, 05 Oct 2012 13:01:47 GMTEvil Kraig Fhttp://www.sqlservercentral.com/Forums/Topic1369163-364-1.aspxyour best solution would be to create multiple dataflows in the control flow area of your package.create your first dataflow to move the data to the single table on your new server.the create the remaining data flows within a sequence container and use the control flow expressions to completetion to ensure your data flows then execute in the correct order .....alternatively, you may just want to have a second data flow reading of the single table and use conditional splits to split the data into logic paths........(I don't know your data or it's complexity but is an alternative). Hope that helpsFri, 05 Oct 2012 10:40:58 GMTdave-djhttp://www.sqlservercentral.com/Forums/Topic1369163-364-1.aspxHiI have one large table in one database and i am am going to move the data and turn it into a normalised relational database with a number of tables.As all the data is coming from a single table is there a way of just importing it once (say into a recordset or something) and then running other data flow tasks from that recordset?and is there a pause transform that will wait till one item is finished before starting?Thanks in advanceFri, 05 Oct 2012 09:56:34 GMTerics44