Need Help to create SSIS package to insert data from muliple Tables into 1 tables in SQL Server 2005

• alokjain_mca

  SSC Enthusiast

  Points: 147

  More actions

  July 24, 2011 at 11:56 pm

  #244797

  Hi Experts,

  I need to create an SSIS Package to insert data from more than one table to one table.

  So please provide me help to get it done.

  I have created a configuration table TblConfig in which I have more than 10 input tables and I want to insert all the record from these 10 tables into 1 partitioning table .

  Thanks in advance,

  Alok Jain

• SinisterPenguin

  SSC Eights!

  Points: 898

  More actions

  July 25, 2011 at 7:41 am

  #1357769

  If I understand your problem correctly as long as all the tables have the same schema (ie same columns and data types) you just need to feed the output from each Source table into a "Union All" object from the toolbox.

  Then take the single output from the Union all to your destination table - this will combine all the records from all your source tables.

• Phil Parkin

  SSC Guru

  Points: 247159

  More actions

  July 25, 2011 at 7:45 am

  #1357773

  Is your source and target data all on the same SQL instance? If so, may I ask why you are using SSIS for this?

  ---

• alokjain_mca

  SSC Enthusiast

  Points: 147

  More actions

  July 25, 2011 at 10:41 pm

  #1358237

  I need to fetch the data from Production server to Development server and from multiple source table to a single destination table. The destination table is a partition table with same schema of Source Table.

  Each Source table having more than 10,00000 Rows.

• SinisterPenguin

  SSC Eights!

  Points: 898

  More actions

  July 26, 2011 at 5:43 am

  #1358390

  Sounds like a data flow using "Union All" is the way to go then....