SSIS Talk

Jamie Thomson and I briefly discussed an issue I was having today with respect to marking sources as sorted (IsSorted=True) and then to later have the IsSorted property changed back to “False” as a result of a derived column transformation. Read on for more…

(more…)

Generating surrogate keys is no sweat in SSIS. Though it does require a custom script to be written. (You might be able to use the Row Number Transformation)

(more…)

I wanted to post about some different ways to work with varying data types in the derived column transformation. Some basic stuff follows:
(more…)