SSIS Trash Destination Adapter (Dummy Destination for Testing)

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

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.

Firstly, You need to Download and Install SSIS ZappySys PowerPack.
Once you finished first step, Open Visual Studio and Create New SSIS Package Project.
Now, Drag and Drop SSIS Data Flow Task from SSIS Toolbox.
Double click on the Data Flow task to see Data Flow designer surface.
From the SSIS toolbox drag and drop ZS DummyData Source on the dataflow designer surface.
Double click DummyData Source and select Customer profile from Template dropdown.
From the SSIS toolbox drag and drop Trash Destination on the data flow designer surface.
Now single click on the DummyData Source once you see blue arrow from source ... connect it to Trash Destination.
Double click on ZS Trash Destination to Configure it.
Click OK to save configure setting UI.
Right click on the path and Add Data Viewer.
Execute the package and verify source data in data viewer.

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

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