Trash Destination Adapter Anchor the output path and set a Data Viewer to examine the results
Download

Trash Destination Adapter Ranking & Summary

Trash Destination Adapter Tags

data viewer SQL Server adapter SSIS Trash Destination

Trash Destination Adapter Description

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.

Trash Destination Adapter Related Software