Building packages in SQL Server Integration Services is easy. Creating an enterprise-ready SSIS architecture takes more effort and planning.

SQL Server Integration Services is deceptively easy to use. With a few hours of instruction or self-study, most data professionals can throw together an SSIS package. However, creating a process that simply runs successfully isn’t the endgame; enterprise-class ETL demands a higher standard. Specifically, well-designed packages will be:
  • Reliable
  • Resilient
  • Reusable
  • Maintainable
  • Well performing
There’s nothing magical about building rock-solid SSIS packages, but it does take some discipline, experience, and a library of best practices. That is exactly the aim of this course: to demonstrate a set of proven practices that help frame the development of enterprise-ready SSIS packages.

In this full-day presentation, we will walk through each of these five facets of well-built packages, discussing and then demonstrating ways of applying these practices to design better SSIS packages. Among the topics for the day:
  • Checking for problems even when the package executes successfully
  • Building effective tests for your packages
  • Error handling and prevention
  • Being kind to your fellow developers by building clear and easy-to-maintain packages
  • Leave a trail of evidence: package logging done properly
  • Avoiding performance bottlenecks: tips for making packages run faster
  • Using the right tool for the job by integrating non-SSIS tools when appropriate
This course is designed for the beginner - to intermediate-level SSIS developer.

A general understanding of SQL Server Integration Services fundamentals
Laptop Required:No

Presented by Tim Mitchell at SQLBits XVII