HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

SSIS: Selecting multiple input columns and mapping them to their respective destination in one action

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
destinationcolumnsssisrespectiveactioninputonemultipleselectingand

Problem

Can selecting multiple available input columns and mapping them to their respective destination be done in one action!?!?! Instead of selecting 1 input at a time! I've tried holding control and the Shift key to select multiple ones and drag them over, but only the one you click on copies over. This is a huge time waster for tables that have multiple columns and for whatever reason SSIS doesn't automatically map them over, even with the columns names matching! I'm in SSIS 2008 R2 BTW.

The image below is just an example to illustrate what I'm talking about, it is not my personal example:

(source: ggpht.com)

Solution

I found the solution, you can Right-click in the column names area on the diagram & Select "Map Items By Matching Names"

(source: hoegaerden.be)

Context

StackExchange Database Administrators Q#150434, answer score: 3

Revisions (0)

No revisions yet.