You work as a database administrator at ABC.com. Your duties include managing a SQL Server
2008 database server named ABC-DB05, which hosts the SQL Server 2008 Integration Services
(SSIS) Data Flow.
The Data Flow inserts the data from a source query into a result table. You receive an instruction
from the CIO to add the rows that are contained in the result table.
Which of the following actions should you take?
A.
Lookup Transformation and a Lookup Data Conversion should be used.
B.
Lookup Data Conversion and Control Flow Job should be used.
C.
Merge Join Transformation and Lookup Transformation should be used.
D.
Control Flow Job and Merge Join Transformation should be used.