SSIS Trash Destination Adapter (Dummy Destination for Testing)

Trash Destination can be used to terminate your dataflow pipeline without doing any expensive processing on incoming data. This component is very useful during testing where you want to focus on source and transforms but don't really care about destination.

Download SSIS PowerPack



In this section you will learn how to use Trash Destination to see your incoming data from source. in few clicks. To make things easier we have use DummyData Source but you may use any type of data source in this example.
  1. Firstly, You need to Download and Install SSIS ZappySys PowerPack.
  2. Once you finished first step, Open Visual Studio and Create New SSIS Package Project.
  3. Now, Drag and Drop SSIS Data Flow Task from SSIS Toolbox.
    SSIS Data Flow Task - Drag and Drop
  4. Double click on the Data Flow task to see Data Flow designer surface.
  5. From the SSIS toolbox drag and drop ZS DummyData Source on the dataflow designer surface.
    SSIS DummyData Source - Drag and Drop
  6. Double click DummyData Source and select Customer profile from Template dropdown.
  7. From the SSIS toolbox drag and drop Trash Destination on the data flow designer surface.
    SSIS Trash Destination - Drag and Drop
  8. Now single click on the DummyData Source once you see blue arrow from source ... connect it to Trash Destination.
  9. Double click on ZS Trash Destination to Configure it.
    SSIS Trash Destination - Configure
  10. Click OK to save configure setting UI.
  11. Right click on the path and Add Data Viewer.
  12. Execute the package and verify source data in data viewer.
    SSIS Trash Destination - Execute


Property Name Description
SaveDataToFile If this property is True then Trash destination will act as simple flat file destination. Any selected input columns will be logged to output file. This is very handy if you want to save buffer data to file.
RowSeparator Specifies row terminator (Default is new line character (CRLF)). This option is ignored if SaveDataToFile=False
ColumnSeparator Specifies column separator (Default is comma. This option is ignored if SaveDataToFile=False
SupportUnicode When this option is True data is saved as Unicode (Supporting international character set). This option is ignored if SaveDataToFile=False
ColumnNamesInFirstRow If this option is True then first row in the file will be column names. This option is ignored if SaveDataToFile=False
QuoteDataIfNeeded If this option is True then any text/datetime value will be surrounded by double quotes. This setting ignore any column separator character between double quotes.
LoggingMode Determines logging detail level. Available options are Normal, Medium, Detailed, Debugging


  • If you check Save Data to File then by default all input columns are logged to file. If you wish to log selected input column then use Advanced Editor (Right click on Trash Destination and Click Advanced Editor). On the Input Columns Tab check/uncheck columns you wish to log in file.

Error handling

  • This component does not support error output .
  • Any bad random value will cause Error or Truncation (e.g. If your sample value is 5 character long but output column length is set to 3 chars). If you have error output attached with RedirectRow option on Error, Truncation then you can capture bad rows along with exact reason of error.

Settings UI

SSIS Trash Destination - Setting UI
SSIS Trash Destination - Setting UI



Copyrights reserved. ZappySys LLC.