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