Need urgent advise Please. I have kind of simple SSIS Package. Here is my package looks like
- OLE DB SOURCE
- Drived Column
- LookUp Transformation Table1
- LookUp Transformation Table2
- LookUp Transformation Table3
- Data Conversion Transformation
- OLE DB Destination
Here is my questions. How can I Use all three LookUp Transformation as "Left Outer Join". I meant to say, I want all values if there is no match found in LookUps.
I know I can use Three Merg Joins Transformation. Is there any other solution?