Building Better SSIS Packages

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.

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