4

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)

0
4

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)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.