DRAG DROP
You are developing a SQL Server Integration Services (SSIS) package to insert new data
into a data mart. The package uses a Lookup transformation to find matches between the
source and destination.
The data flow has the following requirements:
New rows must be inserted.
Lookup failures must be written to a flat file.
In the Lookup transformation, the setting for rows with no matching entries is set to Redirect
rows to no match output. You need to configure the package to direct data into the correct
destinations.
How should you design the data flow outputs? (To answer, drag the appropriate
transformation from the list of answer options to the correct location in the answer area.)
Answer: 
Explanation:
http://msdn.microsoft.com/en-us/library/ms141821.aspx
http://msdn.microsoft.com/en-us/library/bb895366.aspx
OLE DB Source Output
Lookup No Match Output
Lookup Error Output
0
0
The answer is correct.
…Lookup error output…This option is not available when you select Redirect rows to no match output…
http://msdn.microsoft.com/en-us/library/bb895366.aspx
0
0
yes, agreed with you after reading the ref. provided answer is correct.
0
0
I think dbo is right.
It’s excluding in General Tab, but error’s can be redirected in Error Output tab.
The first picture in google for “lookup transformation in ssis” shows
example with all three outputs working.
Answer was corrected in a v5 version of dump, the same number of question 44.
0
0