Single Transformation in SSIS?

• faridh_khan

  SSC Enthusiast

  Points: 149

  More actions

  September 21, 2008 at 11:25 pm

  #123728

  I want to map the Source and Destination columns by Single Transformation in SSIS.

  ie, All the columns in source must be combined together and map to the destination column. Therefore only one line will be there from source to destination.

  We can achieve this task in SQLServer2000 using Copy column while mapping. I need to do it in same way.

  Please advice is it possible in SSIS?

• Prachi-885067

  SSC Veteran

  Points: 208

  More actions

  September 21, 2008 at 11:57 pm

  #874792

  You can add derived column transformation between source and destination to combine all source columns together.

  Or you can write a sql query in Source to combine columns from source and then output of sql query will be mapped to destination column.