Click here to Skip to main content
14,932,737 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I am using SQL Server 2008R2. I have almost 30+ tables in database and now I need to load data from these tables into Data Warehouse.

The problem is that DFT(Data Flow Task) only allow to connect with only one table at time. To connect with other table, you need to have another DFT. Now, to extract data from 30+ tables, It seems that I need to create 30+ DFTs. Moreover! Bulk task only works for files.

So, I have two questions here:

1. How to load data from multiple tables.

2. If I create 30+ DFTs, what impact it will have on Performance.
Posted

1 solution

I believe you can synchronize only one table at a time .
so ull have to create 30+ DFT to synchronize entire db to ur dw
when you look into Bulk insertion it can insert multiple records at a time not multiple table
So the performance will be normal.
   
Comments
Faizan Mubashar 12-Mar-14 7:31am
   
Hmm! I think same. Thanks for reply.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900