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 Read more

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. 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

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

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

FAQ

References