question

Gangadhar.marisetti avatar image
Gangadhar.marisetti asked

how to concate row data through ssis?

source: ename empno stev 100 methew 100 john 101 tom 101 target: ename empno stevmethew 100 johntom 101
ssis
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
ThomasRushton avatar image
ThomasRushton answered
You're looking for the XML string concatenation trick. I've [blogged about it][1], as have [many others][2]. [1]: http://thelonedba.wordpress.com/2011/02/22/string-concatenation-using-xml-path/ [2]: https://www.google.co.uk/search?q=xml+string+concatenation+sql+server
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.