First published on MSDN on Jul 23, 2008
Integration Services Community Samples project
is now active on Codeplex. These samples are being created by the SSIS product team to supplement the content in books online, and the
Product Samples for 2008
. They will (hopefully) provide useful functionality that you can then take an customize for your ETL solutions.
The first two samples are pipeline components. We have an XML Destination, which takes one or more input streams and outputs XML documents, and a RegEx Flat File Source, which allows you to parse flat files using regular expressions.
This sample includes source and binary for a simple XML Destination pipeline component. Use this sample to learn more about how to:
Create custom data flow destination components for use with SSIS
Build component user interfaces
Support multiple inputs on a single component
Regular Expression Flat File Source
This sample includes source and binary for a regular expression based flat file parsing source. Use this sample to learn more about how to:
Create custom data flow sources components for use with SSIS
Support multiple outputs from a single component
Define output columns
These components are pretty easy to use, but I’ll follow up with a couple of posts (with screen shots!!@) that show how to use them.