SSIS Sample Components

Well is seems the flow of add-ins for SSIS is starting. Microsoft has just release a lot of usefuls add-ins for SSIS. I am a big fan of the Regex component as it is often the hardest to code. Check out the links below.

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, matching, extracting, or splitting, as configured by the user.

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: RTrimPlus
RTrimPlus takes a string or unicode column, and removes trailing spaces, whether ASCII, or Japanese.

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: 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: CodePageConvert
CodePageConvert is an SSIS dataflow component that translates from and to any code page or unicode character representations.

SQL Server SSIS Sample Component: ConfigureUnDouble
ConfigureUnDouble takes a text column, and, removes bracketing quotes if present, plus places double quotes inside the text with sinqle quotes.

SQL Server SSIS Sample Component: UnDouble
UnDouble takes a text column, and, removes bracketing quotes if present, plus replaces double quotes inside the text with sinqle quotes.