Category: Windows / Internet

License: Freeware

Limitations :

OS: Windows All

Size: 0.39 MB (407,040 bytes)

Introduction: The Trash Destination Adapter is a development aid. It will allows you to quickly terminate a data flow path, and does not require any configuration. It will consume the rows without any side effects, and prevents warnings or errors you may otherwise receive when executing the data flow. When building data flows you rarely complete them at the first attempt. By terminating the partially completed flow with the Trash Destination, you will not add any overhead to the processing, and it requires no configuration or external resources. You can then quickly add a Data Viewer to the path, and execute the package to check on your progress. For existing packages you may encounter problems, and wish to use an error output for row redirection where you would normally fail the component. Using the Trash Destination and a data viewer to consume and view the failing rows in the development environment is a fast and efficient way to help debug your problem. Requirements: · SQL Server 2005 Integration Services