DRAG DROP
You are developing a SQL Server Integration Services (SSIS) package that imports unsorted data into
a data warehouse hosted on SQL Azure. You have the following requirements:
• A destination table must contain all of the data in two source tables.
• Duplicate records must be inserted into the destination table.
You need to develop a data flow that imports the data while meeting the requirements. How should
you develop the data flow? (To answer, drag the appropriate transformation from the list of
transformations to the correct location in the answer area.)
Answer: 
Explanation:
Reference:
http://msdn.microsoft.com/en-us/library/ms141703.aspx
http://msdn.microsoft.com/en-us/library/ms141775.aspx
http://msdn.microsoft.com/en-us/library/ms141020.aspx
http://msdn.microsoft.com/en-us/library/ms140182.aspx