Helpful information and examples on how to use SQL Server Integration Services.
The 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.
From the releases page:
This sample includes source and binary for a simple XML Destination pipeline component. Use this sample to learn more about how to:
This sample includes source and binary for a regular expression based flat file parsing source. Use this sample to learn more about how to:
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.
PingBack from http://weakbladder.info/story.php?id=6677