You design a SQL Server 2008 Integration Services (SSIS) data flow that inserts data from a
source query to a destination table.
You need to insert only those rows that do not already exist in the destination table.
What are two possible ways to achieve this goal? (Each correct answer presents a complete
solution. Choose two.)
A.
Use the Merge transformation.
B.
Use the Lookup transformation.
C.
Use the Union All transformation.
D.
Use the Merge Join transformation.
E.
Use the Fuzzy Lookup transformation.
F.
Use the Fuzzy Grouping transformation.