First published on MSDN on Apr 04, 2012
An interesting case study about how SSIS is used by Canada Post has
recently been published
. The article mentions how they built an SSIS scale-out solution which processes 10-15 GB of data per day (with four worker nodes). Definitely an interesting read!
If you’d like to know more about building your own scale-out solutions with SSIS, check out the
Designing Your SSIS Packages for Parallelism