sql server - SSIS Data Conversion to OLE DB Destination column mapping -

i using visual studio 2012 (shell) create ssis package import flat file sql server db table.

i have flat file source , ole db destination data conversion component in between.

i use data conversion tool convert columns source unicode string [dt_wstr] wont unicode non unicode error.

i left default output alias names given columns data conversion component original input column name words "copy of" added in front.

i have on 200 columns. when double click on destination component , go map columns, see original column names showing first in drop down of available columns map , when scroll down past first 200 original column names converted column names (the ones copy of).

i don't know how doing earlier have hit down arrow key twice , switch "column 0" "copy of column 0" able tab thru , map columns. (tab, tab, down arrow key, down arrow key , repeat).

now reason have press down arrow key on 200 times past of original columns names able select transformed column names time consuming (and cause rsi).

i want know if can either of following:

1)make transformed column names show in available input columns when mapping columns in ole db destination.

or

2)figure out how able hit down arrow key twice when selecting input column , switch original column name transformed column name (without having hit down arrow key on 200 times transformed column names).

i make sure metadata columns want output table have same name destination columns, manually matching columns different name columns error prone. same names means can right-click mapping , select map name. there several ways around this:

first option change column names in flat file connection manager appending x name - don't have same names present in actual file because works column position. in data conversion can remove 'copy of' , x name , call want.

second option - insert derived column task between data conversion , ole db destination. each non 'copy of'column select replace , add matching 'copy of' column expression.

third , favorite - insert union task between data conversion , ole db destination. in union mapping can rename column editing output column name field , can right-click on column delete it. remove non 'copy of' columns , rename 'copy of's giving need. it's tad strange using union 1 input works.