Hands-On Microsoft SQL Server™ 2005 Integration Services

Data Flow Destinations

A data flow destination is the last component in the Integration Services data flow, as this component has no output columns, though it may have error output columns for redirecting error rows. The data flow destination writes the data that flows to it after undergoing various transformations to an external data store or to an in-memory dataset. You can configure the data flow destination for how to handle errors in data. You can choose to fail the component, ignore the error, or redirect the error rows to the error output columns. If the data flow destination can’t write some of the data rows to the external data store due to errors in data or data not matching with the external columns, it will redirect those rows to ...