September 21, 2008 at 11:25 pm
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?
September 21, 2008 at 11:57 pm
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.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy