SSIS Presentations from SQL Bits Available Online

Three slide decks from the SSIS presentations I did at SQL Bits X in London have been posted online. These include: SSIS Performance Design Patterns – full day training session! What’s New in SSIS for SQL Server 2012 – breakdown of the new features and functionality in SQL Server 2012 SSIS Catalog – Overview of…


Microsoft Connectors v2.0 for Oracle and Teradata – Now Available

The new Attunity connectors for Oracle and Teradata are now available on Microsoft.com. This version (v2.0) supports SQL Server 2012, and adds some new functionality for SQL Server 2008 / 2008 R2 (v1.2). From the site: Microsoft Connector Version 2.0 for Oracle by Attunity – The Oracle source and destination components are written to achieve…


SSIS Case Study – Innovapost

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…