July 24, 2011 at 11:56 pm
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
July 25, 2011 at 7:41 am
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.
July 25, 2011 at 7:45 am
Is your source and target data all on the same SQL instance? If so, may I ask why you are using SSIS for this?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
July 25, 2011 at 10:41 pm
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.
July 26, 2011 at 5:43 am
Sounds like a data flow using "Union All" is the way to go then....
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply