February 2014

Microsoft quietly added two functions to their SSIS expression language: Token and TokenCount. I think that these functions will find their way into any serious SSIS developer’s tool belt. Here I show how you can use this to solve a very common problem, interpreting dates. When importing data, frequently one column of data will need […]

When I think of a variable in programming, I thing of a construct that is not much more costly to use than the equivalent constant.  Thus, if I had the following loop in C#, I could replace the variable “splitString” with a constant and the performance impact would be minimal. int splitLength = 3; string