title: Second lookup based off the first lookup output
body: <p>Using a data flow task in SSIS,for a specific Id I need to fetch a description from two tables.First table should be join on ParentTable.Id to get ParentTabel.Description and second join should be with SubCatagoryTable.ParentId column to get SubCatagoryTable.Description. Then I have to keep then non NULL value, except if both description is NULL. </p>