blogs.conchango.com

Its possible that at some point when building SSIS packages that you will want to initialise a variable with some value at execution time and the most obvious way of doing this is to use a script task. That code would look something like the following: Public Sub Main() Dim vars As Variables ...

  That’s what I twittered recently upon first opening up Release Candidate 0 of SQL Server 2008. You may remember that back in March of this year I told you about a new feature that would be appearing in a future CTP; namely that a container would provide information about its parent container. Hence if you peer into the depths of this ...

I've had an idea about how I'd like to use connection managers, variables, and consequently, configurations and its quite a diversion from how I manage these object types in SSIS currently. Quite simply I'm toying with the idea of storing all my connection strings in variables and then using expressions to apply those connection ...

I thought it would be worth publishing a list of guidelines that I see as SSIS development best practices. These are my own opinions and are based upon my experience of using SSIS over the past 18 months. I am not saying you should take them as gospel but these are generally tried and tested methods and if nothing else should serve as a basis ...