DRAG DROP
You are developing a SQL Server Integration Services (SSIS) package that loads data into a data
warehouse hosted on Windows Azure SQL Database.
You must combine two data sources together by using the ProductID column to provide complete
details for each record. The data retrieved from each data source is sorted in ascending order by the
ProductID column.
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: 