SSIS Case Study – Innovapost

Published Mar 25 2019 03:32 PM 310 Views
Not applicable
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 video.

%3CLINGO-SUB%20id%3D%22lingo-sub-388075%22%20slang%3D%22en-US%22%3ESSIS%20Case%20Study%20%E2%80%93%20Innovapost%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-388075%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3E%20First%20published%20on%20MSDN%20on%20Apr%2004%2C%202012%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%3CP%3EAn%20interesting%20case%20study%20about%20how%20SSIS%20is%20used%20by%20Canada%20Post%20has%20%3CA%20href%3D%22http%3A%2F%2Fwww.microsoft.com%2Fcasestudies%2FMicrosoft-SQL-Server-2008-Enterprise%2FInnovapost%2FIT-Services-Firm-Collects-Cleans-and-Quickly-Distributes-Data-to-Support-Better-Decisions%2F710000000379%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20recently%20been%20published%20%3C%2FA%3E%20.%20The%20article%20mentions%20how%20they%20built%20an%20SSIS%20scale-out%20solution%20which%20processes%2010-15%20GB%20of%20data%20per%20day%20(with%20four%20worker%20nodes).%20Definitely%20an%20interesting%20read!%3C%2FP%3E%0A%20%20%3CP%3EIf%20you%E2%80%99d%20like%20to%20know%20more%20about%20building%20your%20own%20scale-out%20solutions%20with%20SSIS%2C%20check%20out%20the%20%3CA%20href%3D%22http%3A%2F%2Fmsdn.microsoft.com%2Fen-us%2Flibrary%2Fdd795221.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20Designing%20Your%20SSIS%20Packages%20for%20Parallelism%20%3C%2FA%3E%20video.%3C%2FP%3E%0A%20%0A%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-388075%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20MSDN%20on%20Apr%2004%2C%202012%20An%20interesting%20case%20study%20about%20how%20SSIS%20is%20used%20by%20Canada%20Post%20has%20recently%20been%20published.%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-388075%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Ecase%20study%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPerformance%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Escale%20out%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Essis%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Version history
Last update:
‎Mar 25 2019 03:32 PM
Updated by: