Hi All, This is Regarding SSIS. I have two sources...One is oracle and the other is Excel. The data is coming from these 2 sources and looks like following : From Oracle : From Excel : ID Number ID Name 1 4567 1 Telecmp 1 336 1 Matrix assoc 1 34889 2 Signa 2 6799 2 Mandal assoc 3 34 3 New Delhi Assoc 3 56 4 Mumbai Tele assoc 3 897 4 Six Sigma 4 75 5 Signa I have to merge the data based on ID Column and Get the Number And Name ... The Output should look like this : ID Number Name 1 | 4567, 336 , 34889 | Telecmp ,Matrix assoc , Signa 2 | 6799 | Signa,Mandal assoc ...etc Can anyone tell me how to acheive the above output using ssis components............After Merge join I am not getting any idea ..... to take forward inorder to get this kind of output... Apprepriate ur suggestions ....Pls let me know ASAP. Thanks, vineesh1701

You can use Sort Task and Merge join Task will help you out.

Maybe a 'simple' asynchronous Script Component.Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

Can anyone tell me how to acheive the above output using ssis components............After Merge join I am not getting any idea ..... to take forward inorder to get this kind of output... Apprepriate ur suggestions ....Pls let me know ASAP. Thanks, vineesh1701 Hi Vineesh, Use a script compoent after the merge task to work asynchronously as a Transform. Loop through all the records and keep appending the Name and Number till the ID does not change. If it changes send the concatenated values along with the id to the output. PS. Sort the data from oracle in the OLEDB source itself instead of using Sort transform in SSIS.My Blog | Ask Me