Trash Destination Adapter

Posted on SQL Server Central See other posts from SQL Server Central
Published on Fri, 06 Jul 2012 06:00:00 UT Indexed on 2012/07/06 9:21 UTC
Read the original article Hit count: 144

Filed under:

The Trash Destination and this article came from early experiences of using SSIS and community feedback at the time. When developing a package it is very useful to have a destination adapter that does nothing but consume rows with no setup requirement. You often want run a package part way through development, or just add a path so you can set a Data Viewer. There are stock tasks that can be used, but with the Trash Destination all columns are treated as selected automatically (usage type of read-only), so the pipeline knows they are required.

© SQL Server Central or respective owner