Agile BI Community

A number of the SSIS MVPs were asked to contribute a white paper to MSDN a few months ago, and those articles were published recently. You'll notice a common thread in most of the topics: Considerations for High Volume ETL Using SQL Server Integration Services by Pat Martin Reusing Connections with Data Sources and Configurations by ...

I'm presenting at the Midlands PASS chapter in Columbia, SC tomorrow night, July 17th. I'll be presenting on SSIS configurations and some common approaches for implementing them. Configurations are one of the best features about SSIS, but also one of the most confusing. If you're in the area, and would like to learn more, please stop by.

In a previous post, I detailed some of the challenges that I had encountered when trying to modify the connection string used for SQL Server configurations from the command line. In SSIS 2005, command line options were applied after the configurations were loaded (with the exception of parent package variables). Effectively, this meant that you ...

There's an interesting ''behavior'' that occurs with configurations at design time. The value of the configuration will be saved in your package as the new stored value. I'd seen this before, but never really thought about it, until a poster on the forums questioned why it was happening. To understand it, you need to know how the package is ...

As part of my standard approach (and the one used by Mariner), I use configurations in SSIS quite heavily. My preference is to use the SQL Server configuration type, since it keeps all the configurations in one place. XML configurations tend to result in a lot of extra files to manage. With SQL Server based configurations, though, you need to ...

This tool can be used to edit database or XML based SSIS Configurations.  What it does: Allows you to add, edit, and delete configuration items in existing XML configuration files. Allows you to add, edit, and delete configuration items in existing configuration database tables. What it doesn't do: Create new XML configuration files ...