Remove Columns from Destination in SSIS

INBAR 21 Reputation points

I added derived columns to my package to take care of nulls. I don't want to replace the old columns with the new derived columns but I do not want to old columns to show up. How do I remove them from my destination? 192549-shitfuck.png

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,046 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,849 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,484 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,255 questions
0 comments No comments
{count} votes

Accepted answer
  1. Olaf Helper 42,451 Reputation points

    If you select a database table as destination, then always all columns of the destination table are shown; some different behaviour wouldn't make sense.

0 additional answers

Sort by: Most helpful