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 ...

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 ...