Archives: September 2010

There are a few times where you might want to perform a cross join/cartesian join/cartesian product operation in SSIS. One of those scenarios could be performing some kind of a double-sided "range join" where you can't line up a specific key in your data flow to a specific key in your lookup table. Quite often…

This question just came up in the forums, and it highlights how difficult it can be to try to optimize Integration Services. It's difficult because the SSIS concept of the Data Flow - an in-memory pipeline of buffers - isn't the paradigm that a great many of its users are…