Integration Services Samples for SQL Server 2008

Published Mar 25 2019 02:06 PM 52 Views
Not applicable
First published on MSDN on May 21, 2008

Now that things are winding down for SQL Server 2008, we've had some time to focus on samples. I'm especially interested in publishing sample extensions (tasks, data flow components, etc) out on codeplex, but we're also working on SSIS package samples that make use of some new functionality in 2008.

Here are some of the custom extensions we have so far:

  • XML Destination
  • RegEx Source - parse a text file using regular expressions
  • Partition Management Task - based on an existing codeplex project
  • Database Population Task - populate a database/table with random data
  • Random Data Source

In the next couple of months we'll be making these available via Codeplex. I'll also try and provide some early binary preview versions if there is enough interest.

I thought I'd post and see if there was any specific features / functionality we have in our stock extensions that you'd like to see exposed in a sample. For example:

  • Persisting sensitive fields (passwords in connection managers)
  • Filtering on connection manager type in a properties grid
  • Handling multiple inputs in a data flow component
  • Custom UIs

What else would you like to see?

Version history
Last update:
‎Mar 25 2019 02:06 PM
Updated by: