Download Trash Destination Adapter 2.0.0.33 / 1.0.2.18

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.

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 Trash Destination 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.

Trash Destination Adapter will simply place the files on disk in the correct locations and also install the assemblies in the Global Assembly Cache as per Microsoft’s recommendations.

Requirements:



· Microsoft SQL Server 2005 or 2008

What's New in This Release: [ read full changelog ]



· SQL Server 2008 release. Includes support for upgrade of 2005 packages. RTM compatible, previously February 2008 CTP.