Subscribe to this blog
Archives: September 2010
Performing a Cross Join (Cartesian Product) in SSIS
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…
0 comments, 568 reads
Posted in Todd McDermid's Blog on 28 September 2010
Parallelism in SSIS - Multiple Lookups
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…
1 comments, 380 reads
Posted in Todd McDermid's Blog on 6 September 2010