I am having 34 columns in the source and destination table, i want to
move all the data to the destination table in single transformation by
SSIS. I dont want map each column in the source and destination (ie; 34
lines). I am trying to map this in the

Dataflow tab-->OLEDB Destination --> Mappings tab.

I want to combine all the columns in the source and pass the value to
the destination in single line (Not 34 lines) as we can do it in
SQLServer 2000.

Please post your answers if you have idea on this.

*** Sent via Developersdex http://www.developersdex.com ***