HOTSPOT
You are developing a SQL Server Integration Services (SSIS) package to implement an incremental data
load strategy. The package reads rows from a source system and compares them to rows in a
destination system. New rows will be inserted and changed rows will be updated.
You have used a Lookup transformation and a Conditional Split transformation. The Lookup
transformation joins the source and destination table on the business key, and includes all columns from
the destination table in the data flow output. The Conditional Split transformation inspects the
destination columns and directs data flow to either insert new records or update existing records.
You need to configure the Lookup transformation to ensure that all records flow to the Conditional Split
transformation, regardless of whether the rows match an existing row in the destination table.
Which setting should you select? (To answer, select the appropriate option in the answer area.)
Answer: 