SSIS Trash Destination Adapter (Dummy Destination for Testing)
PreviousNext

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

Content

Step-By-Step

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. From the SSIS toolbox drag and drop Data Flow Task on the controlflow designer surface.
  2. Double click on the DataFlow task to see DataFlow designer surface.
  3. From the SSIS toolbox drag and drop ZS DummyData Source on the dataflow designer surface.
  4. From the SSIS toolbox drag and drop ZS Trash Destination on the dataflow designer surface.
  5. Now single click on the DummyData Source once you see blue arrow from source ... connect it to Trash Destination.
  6. Right click on the path and Add Data Viewer.
  7. Execute the package and verify source data in data viewer.
    configure-ssis-trash-destination

Properties

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

Remarks

Error handling

Settings UI

ui-trash-destination-settings

FAQ

References


Copyrights reserved. ZappySys LLC.