SSIS Sample Transforms


The SSIS team have been busy shipping a bunch of really useful and cool sample transforms;


SQL Server SSIS Sample Component: CalendarTransform


CalendarTransform is an SSIS dataflow transform component that generates standard calendar attributes.


 


SQL Server SSIS Sample Component: UnDoubleOut


UnDoubleOut is an SSIS dataflow component that removes qualifiers from quoted text, either in place, or via the creation of a new output column.


 


SQL Server SSIS Sample Component: Regex


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.


 


SQL Server SSIS Sample Component: RTrimPlus


RTrimPlus takes a string or unicode column, and removes trailing spaces, whether ASCII, or Japanese.


 


SQL Server SSIS Sample Component: NullDetector


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.


 


SQL Server SSIS Sample Component: SeeBuffer


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.


 


SQL Server SSIS Sample Component: UnpackDecimal


UnpackDecimal takes an input column formatted in packed decimal (comp-3), and generates the corresponding Decimal value.


 


SQL Server SSIS Sample Component: CodePageConvert


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)

Comments (4)

  1. Brad White says:

    I must be a little slow today.  What are these and why do I care?

  2. euanga says:

    Brad,

    These are sample transforms for integration services. You would care if you needed the functionality they provided or if you wanted to learn more about writing transforms yourself.

  3. Darren says:

    They are sample SSIS components. If you want to learn how to write your own components, then they demonstrate the key concepts for most of the types of components, including some of the more advanced patterns. You may also have a need for one of the more functional components, in which case, compile it and use it.

    The Regex component implements regular expression functionality, rather than being a copy of RTRimPlus.

  4. Brad White says:

    OK, I get it.   Thanks.

    In retrospect, I’m guessing that SSIS stands

    for SQL Server Integration Services.

    For anyone else interested but confused,

    http://msdn.microsoft.com/sql/bi/integration/

    has an FAQ "Tell Me Why"

    and an introduction to SSIS