Hi @Shambhu Rai ,
What component are you using in your package? Are you using the T-sql code in the package to merge the data?
Could you please share us your table structure (CREATE TABLE …) and some sample data (INSERT INTO …) along with the code you are using? So that we’ll get a right direction and make some test.
The error message is clearly that you need to refine the ON clause to ensure a target row matches at most one source row, or use the GROUP BY clause to group the source rows.
Regards,
Zoe Hui
If the answer is helpful, please click "Accept Answer" and upvote it.