How can I delete the columns in DataFlow Task in SSIS?

sql-server ssis sql-server-2016 ssis-2016
Ardalan Shahgholi picture Ardalan Shahgholi · Mar 8, 2017 · Viewed 7.7k times · Source

I use SQL Server 2016 and I have a very busy DataFlow task. In my DataFlow task, I use Multicast component for some reason. After creating a new Flow in my DataFlow, I need to delete some of the columns in the new flow because they are useless.

enter image description here

Just for more information, I need to do that because I have more than 200 columns in my flow and I need less than 10 of those columns.

How can I delete the columns in DataFlow Task in SSIS?

Answer

C B picture C B · Mar 8, 2017

I believe that you can pass just one data flow path to a UNION ALL task to remove columns from that single data flow.

Take the single data flow path that you would like to remove columns from and pass it to a Union All task. Then open up the Union All task right click on the column(s) you would like to remove from that path and select delete.

Usually I think the source of the data should be altered to not send the unwanted columns out, but your case is special. With one path out of the multicast needing all of the columns from the source, while one path does not.

Related questions

Run SSIS Package Without SQL Server Integration Services

Can we run SSIS Package without integration services? If Yes then what are the steps? If No then what is the minimum requirement. The problem statement is as follow: I am using SQL Azure database to store the data. I …

Read More
SSIS Failed to acquire connection. Connection may not be configured correctly or you may not have the right permissions on this connection

I'm using MS SQL Server 2016. I have a SSIS package, with one execute SQL task. I can execute it fine with Visual Studio. When I deploy to the SSIS Catalog, I receive the below error: Execute SQL Task: Error: Failed …

Read More
SSIS Error: VS_NEEDSNEWMETADATA

I'm currently updating all of our ETLs using Visual Studio 2015 (made in BIDS 2008) and redeploying them to a new reporting server running on SQL Server 2016 (originally 2008R2). While updating one of the ETLs and trying to run on the new …

Read More