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: 162
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