SSIS Loading Data from Multiple Tables

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.

I have seen following links:

But wasn't able to get satisfactory answer. Second link says, you may create as many S2D tasks as you can but again a performance trade off.

Help is required. Thank You!

Answers


Please let me know whether all the tables have got same structure? Do you want to laod all these source tables into a single target table?In the dataflow task ,under SQL command,you can use a union all if all the tables have got same structure


Need Your Help

PopupMenu - Customize Text (Size/Color) in Menu Resource Items

android android-menu

I have created a PopupMenu that is inflated OnClick of a LinearLayout. I want the Menu Items to have a specific textColor and textSize; however, Menu Items seem to have a very restricted set of XML

WCF Web Service Request Error when calling with json data including danish characters

.net ios wcf web-services

My WCF Web Service (svc-file) returns Request Error when trying to send data in json including danish characters like æ, ø, å.