Microsoft
70-448 · Question #280
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…
The correct answer is B. Use the Lookup transformation. D. Use the Merge Join transformation. See the full explanation below for the reasoning.
Question
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.)
Options
- AUse the Merge transformation.
- BUse the Lookup transformation.
- CUse the Union All transformation.
- DUse the Merge Join transformation.
- EUse the Fuzzy Lookup transformation.
- FUse the Fuzzy Grouping transformation.
How the community answered
(69 responses)- A12% (8)
- B77% (53)
- C7% (5)
- E1% (1)
- F3% (2)
Community Discussion
No community discussion yet for this question.