question

sajal01552 avatar image
sajal01552 asked

How to load data from multiple tables to multiple tables by using SSIS

I am using SQL Server 2008 R2. I have almost 106+ tables in database and now I need to load data from these tables into another database. Table structure of source and destination database are same. There is a status table in the database and all tables have a Primary Key ID field. All the tables have Primary key and Foreign key relationship. I need to transfer data those ID number will match with Status table where ID status is 1 or something like this. I need to insert Identity column also, and because of all the table have PK and FK relationship so i have to insert data into tables with referential constraints. So, my questions here is: To fulfill my above scenario how can I load data from multiple tables to multiple tables by using SSIS because it is not one time thing.
sql-server-2008sqlssissql-serverc#
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
JohnM avatar image
JohnM answered
Is this a one time thing? Have you considered using Red Gate's Data compare tool? It can easily load all 106+ tables. You can get a 15 day trial version. I know that's not what you were looking for but I suspect it'd be a lot easier than trying to do this within SSIS. It's possible within SSIS just not fun to put together. http://www.red-gate.com/products/sql-development/sql-data-compare/ Hope that helps!
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

It is not one time thing, so I want to use SSIS
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.