Actions and Detail Panel
Building Better SSIS Packages
Thu, June 1, 2017, 8:30 AM – 5:00 PM CDT
Building packages in SQL Server Integration Services is easy. Building good packages takes a bit more effort.
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:
- 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.