(Using BIDS 2008 R2)
Reuse input column
Is there any way to map a input column to two destination columns?
State static value instead of mapping column
I have a package for each version of the production system - they insert in the same destination tables - I just need to add a version number to the version column - like '2.1' and '3.0'. The only way I have found so far is to select a fake column
in the source like select '2.2' as Version, ..- This is however not very smart when I'm selecting millions of rows.
I would just like to be able to type in a static value instead of mapping a column - any way to do this?
View Complete Post