How should you design the data flow outputs?

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.)

View Answer

Answer:

Explanation:

Records that have no match in the destination are new records and so should be inserted.

Any errors should be recorded in the flat file.

References:

http://msdn.microsoft.com/en-us/lib rary/ms141821.aspx

http://msdn.microsoft.com/en-us/library/bb89 5366.aspx

https:// www.simple-talk.com/sql/ssis/implementing-l ookup-logic-in-sql-server-integration-services/