First published on MSDN on Apr 04, 2012
An interesting case study about how SSIS is used by Canada Post has http://www.microsoft.com/casestudies/Microsoft-SQL-Server-2008-Enterprise/Innovapost/IT-Services-Firm-Collects-Cleans-and-Quickly-Distributes-Data-to-Support-Better-Decisions/710000000379 . 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 http://msdn.microsoft.com/en-us/library/dd795221.aspx video.
Updated Mar 25, 2019
Version 2.0