Hi @Jaiswal, Manali ,
SSIS has Merge Join Transformation for that. No need to deal with comma separated lists.
It is a transformation that allows joining data from two sorted datasets using a FULL, LEFT, or INNER join.
So, your Data Flow Task will need the following:
- two OLEDB sources
- Merge Join transformation
- OLEDB destination
Useful link: ssis-basics-using-the-merge-join-transformation