The Organize Columns component allows you to easily remove, rename, re-order and change the type of columns within a data-flow. It also allows you to specify an optional filter expression - rows not passing the filter condition will not be passed further down the data-flow.

The configuration interface is shown below :



You should check the columns that you want to retain, and you can use the Edit Name / Type... button to modify the name or type. Use the Up or Down arrows to change the relative position of the selected column.



The Filter page allows you to specify a simple filter condition. Rows that do not satisfy these criteria will not progress to the component output.  You can insert variable and column topkens using [column] or @variable syntax, or using the Insert Token link.

All BlueSSIS data-flow components support properties 'Fail on truncation' and 'Unicode mode', allowing you to define applicable truncation and Unicode settings. These properties can be found in the Visual Studio/BIDS Properties window as shown below :