In this article I’ll conclude my set of articles into SSIS configuration. This article will be slightly more verbose than the previous two, but I hope I clearly convey the logic behind my method. If you haven’t yet done so, please read Part 1 and Part 2 of the series.
The Portability problem
In my first forays... More
In Part 1 I showed how a simple SSIS package could be created using variables and expressions as a basis for deployable configuration. When I first started working with SSIS I assumed naively that during deployment, a wizard or a configuration file would allow the variables and expressions to be readily editable. Speaking o... More
This is the first part of a two-part post about creating and deploying a simple SSIS package. When I first started this I was a complete novice as regards SSIS. I thought it was 'something like' DTS, which I had used quite frequently in SQL Server 2000. To make matters worse, I never actually got round to learning it even w... More