The SSIS team have been busy shipping a bunch of really useful and cool sample transforms;
CalendarTransform is an SSIS dataflow transform component that generates standard calendar attributes.
UnDoubleOut is an SSIS dataflow component that removes qualifiers from quoted text, either in place, or via the creation of a new output column.
Regex is an SSIS dataflow component that applies a configured regular expression against an incoming column.
- Rows with no match can be routed to the error output, fail the data flow, or be ignored.
- The matched string, as well as any matching substrings, are placed in new dataflow columns.
RTrimPlus takes a string or unicode column, and removes trailing spaces, whether ASCII, or Japanese.
NullDetector is an SSIS dataflow component that sits astride a data flow, and, depending on whether the value of a user-indicated column is null or not, routes rows to one or the other of its outputs.
SeeBuffer is an SSIS dataflow component that sits in a data flow and is provided a look at each buffer that is presented to it.
UnpackDecimal takes an input column formatted in packed decimal (comp-3), and generates the corresponding Decimal value.
CodePageConvert is an SSIS dataflow component that translates from and to any code page or unicode character representations.
Update: Fixed the description for RegEx(thx Darren)