fez
Reputation: 1835
Visual Studio 2012 - Deleting multiple SSIS Column Mappings in Data Flow Task
Is there a way to remove all column mappings in a SSIS data flow task in one step? In the example below, if I wanted to remove all the mappings I would have to individually click each arrow (using 'ctrl+click') and then hit the 'delete' button.
This is not ideal if I have a table with >20 columns! Does anyone have any tips or tricks that could help?
Thanks!
Upvotes: 1
Views: 529
Answers (1)
mxix
Reputation: 3659
Right-Click the background and you should have the option to 'Select All Mappings', Repeat Right-Click 'Delete selected mappings'.
Upvotes: 1
Related Questions
- SSIS Delete redundant columns in pipeline
- SSIS: Manage broken Data Flow Task because Excel column name changed?
- How to remove particular columns in SSIS package while doing transformation?
- SSIS - Set duplicate columns to null
- How can I delete the columns in DataFlow Task in SSIS?
- Integration Service: How do I change the structure of a SQL Server table in a Data Flow task?
- Remove duplicates in SSIS Data Flow
- SSIS column mapping in Data Flow task when number of columns is high
- Programmatically edit SQL in Data Flow task (SSIS 2005)
- How to delete rows based on comparison from Data Flow Task in an SSIS?