BI Thoughts and Theories

Occasionally, you may run into the need to pass values between packages. In most cases, you can use a Parent Package Variable configuration to pass the value of a variable in the calling (or parent) package to the called (or child) package. However, Parent Read More...

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

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

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

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

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