How to delete columns in DataFlow in SSIS?

Question

I use SQL Server 2016and am very busy DataFlow task. In mine DataFlow taskI use Multicast componentfor some reason. After creating a new stream in mine, DataFlowI need to delete some of the columns in the new stream, because they are useless.

Just for more information, I need to do this because I have more than 200 columns in my stream and I need less than 10 of these columns.

How to delete columns in DataFlow taskin SSIS?

Answer 1

- . . , , , . , , , . , . , , .

, , , :

• . , , . , .
• . , . , . , , , . . , , , .
• . SSIS - , . , , , "--".
• , . , , . , ETL , , , , . , , , . .
• . , . , , " " OLEDB oledb. , ( ).

, .

Answer 2

, UNION ALL, .

, , UNION ALL. UNION ALL (), , delete.

, , , . , , .

Answer 3

, , , , , , Multicast Then The component that will reduce the column number...

:

• DataFlow Task (: OLEDB ),

• You can add Script componentwith asynchronous output (as shown in the figure below) and add the columns specified to the output, map them using Vb.net or C # script, something like this:

  Output0Buffer.AddRow()
  Output0Budder.OutColumn = Row.inColumn
  

3. Add a component UNION ALLand select the desired columns.

Side note. Test well the performance of each scenario and choose the best