rerer
October 5, 2012 at 5:29 am
Please provide more details. What columns you have in source table? What do you have in destination table?
If the joins vary, you can create three OLE DB Source and use merge to join the three output into one and then insert this output into your destination table.
Vikash Kumar Singh || www.singhvikash.in
Joginipelli Malathi (10/5/2012)
I have three source table and one destination table mysql joins vary based on source table how i can write this in ssis
If you can do all the joins in one single SQL statement, do that. Just use one single OLE DB Source (or ADO.NET if there isn't an OLE DB driver for MySQL) and put your SQL statement there. This will garantuee you the best performance.
If this isn't an option, put 3 select statements in 3 seperate sources and include an ORDER BY clause in each of them. Use a MERGE JOIN (not a MERGE) to join the 3 sources together. This component needs sorted data, so that's why you need to include the ORDER BY.
Sort Data for the Merge and Merge Join Transformations
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply