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.