Hi All, I have following tables in my source. table1 , table2 , table3. I know how to import the data from these tables individually but was wondering is there is any way of loading the data from all these tables within one data flow and not mapping each table individually. Thanks Aash

Because you want the data from all those tables mixed up into one destination table? Talk to me now on

Check this thread http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/80b80533-cc88-4e50-96d3-bdc9d3cb72dd

@SqlRockss do u have an example which shows how to loop through tables and load them in database ? ThanksAash

Here's the example : http://consultingblogs.emc.com/jamiethomson/archive/2005/05/30/SSIS_3A00_-Enumerating-files-in-a-Foreach-loop.aspx http://www.sqlis.com/sqlis/post/Looping-over-files-with-the-Foreach-Loop.aspx http://www.rafael-salas.com/2009/05/ssis-foreach-loop-looping-through.html

I have done excatly what is mentioned in the link but used Foreach ADO Enumerator and using option all tables and used a variable but how to use this data flow to load all tables.Aash

Are you loading these 3 tables from any text file or excel file or single sql table?

from seperate 3 tables i.e source tablesAash

So let me get this straight, you want to load 3 tables(in single OLEDB destinaion ) from 3 seperate source tables in single data flow task. If that is the case then we cant do that in SSIS. You can configure it for only one table. You can load data into multiple tables from single OLEDB source using multicast or condtional split.

Of course he can do that in SSIS. Sources A, B, and C can be sent independently to Destinations X, Y, and Z. The data flows need not interact. Talk to me now on

Hi Todd, Thats right. we can do that independetly but i guess multiple tables in single OLEDB destination is not possible right? here's the thread i saw on that http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/18da9172-5a71-4596-8b89-fa0044b8f507

You are correct there. You can only target one destination table per OLE DB Destination. Unfortunately, Aash hasn't been particularly clear as to what he/she is actually attempting to accomplish. Aash? Can you provide more information? Talk to me now on