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

in a data flow task use two sources, one for oracle and another for excel then use sort transform after each of them and sort them then connect output of sort to a Merge Join transform you can set type of join as you want ( inner , left ) and set joining field then you can access joined data at the output of merge join trasnform.http://www.rad.pasfu.com

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

This isn't as simple as the others have described. You'll need TWO asynchronous script components in order to "aggregate" each input's Number or Name column data into one row per ID. The scripts for each input will look largely the same, but you still need two. After those scripts, you can sort by ID and Merge Join. But you can't Merge Join then use an asynchronous script without running into a lot of trouble with duplicate values. Talk to me now on

HI, I have already done till merge join...after that how should I proceed further...........?? (Based on ID matching I got the name and number ....But the output should be like this : 1 | 4567, 336 , 34889 | Telecmp ,Matrix assoc , Signa ...I have a question how to acheive this ...? vineesh1701