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. It is also obvious that this is for development or diagnostic purposes, and is clearly not a part of the functional design of the package. It is also ideal for just playing around and exploring concepts in SSIS, and is often used in conjunction with the Data Generator Source. Using these two components it is easy to setup a test of an expression in the Derived Column Transformation for example. The Data Generator Source provides some dummy data, and the Trash Destination allows you to anchor the output path and set a Data Viewer to examine the results.
It can also be used when performance tuning packages. It is a consistent and known quantity that has no external influences, so it is ideal as a destination when breaking the data flow into sections to isolate a bottleneck.
The adapter is really simple to use and requires no setup. Simply drop it onto the pipeline designer and use it to terminate your data flow path.
The component is provided as an MSI file, however to complete the installation, you will have to add the transformation to the Visual Studio toolbox by hand. This process has been described in detail in the related FAQ entry for How do I install a task or transform component?, just select Trash Destination in the Choose Toolbox Items window.
Downloads
The Trash Destination is available for both SQL Server 2005 and SQL Server 2008. Please choose the version to match your SQL Server version, or you can install both versions and use them side by side if you have both SQL Server 2005 and SQL Server 2008 installed.
Trash Destination for SQL Server 2005
Trash Destination for SQL Server 2008
Version History
SQL Server 2008
Version 2.0.0.33 - SQL Server 2008 release. Includes support for upgrade of 2005 packages. RTM compatible, previously February 2008 CTP.
(4 Mar 2008)
Version 2.0.0.31 - SQL Server 2008 November 2007 CTP.
(14 Feb 2008)
SQL Server 2005
Version 1.0.2.18 - SQL Server 2005 RTM Refresh. SP1 Compatibility Testing.
(12 Jun 2006)
Version 1.0.1.1 - SQL Server 2005 IDW 15 June CTP. Minor enhancements over v1.0.1.0.
(11 Jun 2005)
Version 1.0.1.0 - SQL Server 2005 IDW 14 April CTP. First Public Release.
(30 May 2005)