The http://www.codeplex.com/SQLSrvIntegrationSrv is now active on Codeplex. These samples are being created by the SSIS product team to supplement the content in books online, and the http://www.codeplex.com/MSFTISProdSamples/ . 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.
From the http://www.codeplex.com/SQLSrvIntegrationSrv/Release/ProjectReleases.aspx?ReleaseId=15424 :
XML Destination
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
- Validate metadata
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.
