Building Better SSIS Packages - Tim Mitchell

SQL Saturday 954, presented by Atlanta MDF

About the course
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:
<UL>
<LI CLASS="MsoNormal">Reliable</LI>
<LI CLASS="MsoNormal">Resilient</LI>
<LI CLASS="MsoNormal">Reusable</LI>
<LI CLASS="MsoNormal">Maintainable</LI>
<LI CLASS="MsoNormal">Well performing</LI>
</UL>
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:
<UL>
<LI CLASS="MsoNormal">Checking for problems even when the package executes successfully</LI>
<LI CLASS="MsoNormal">Building effective tests for your packages</LI>
<LI CLASS="MsoNormal">Error handling and prevention</LI>
<LI CLASS="MsoNormal">Being kind to your fellow developers by building clear and easy-to- maintain packages</LI>
<LI CLASS="MsoNormal">Leave a trail of evidence: package logging done properly</LI>
<LI CLASS="MsoNormal">Avoiding performance bottlenecks: tips for making packages run faster</LI>
<LI CLASS="MsoNormal">Using the right tool for the job by integrating non-SSIS tools when appropriate</LI>
</UL>
This course is designed for the beginner- to intermediate-level SSIS developer.
About the instructor
<IMG ALT="Tim Mitchell" SRC="https://i0.wp.com/www.timmitchell.net/wp-content/uploads/2013/01/tmitch2.jpg?resize=150%2C150&ssl=1">
Tim Mitchell is a business intelligence consultant, author, and trainer. He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor's Degree in Computer Science from Texas A&M at Commerce, and is recognized as a <A HREF="https://mvp.microsoft.com/en-us/PublicProfile/4027186" TARGET="_blank" DATA-MSYS-CLICKTRACK="0" REL="nofollow noopener noreferrer">Microsoft Data Platform MVP</A>. Tim is the founder and principal data architect at <A HREF="http://www.tyleris.com/" TARGET="_blank" TITLE="Tyleris Data Solutions" DATA-MSYS-CLICKTRACK="0" REL="nofollow noopener noreferrer">Tyleris Data Solutions</A>.
As an active member of the community, Tim has spoken at international, regional, and local venues including the <A HREF="http://www.sqlpass.org/" TARGET="_blank" DATA-MSYS-CLICKTRACK="0" REL="nofollow noopener noreferrer">SQL PASS</A> Summit, <A HREF="http://www.sqlbits.com/" TARGET="_blank" DATA-MSYS-CLICKTRACK="0" REL="nofollow noopener noreferrer">SQLBits</A>, <A HREF="http://www.sqlconnections.com/" TARGET="_blank" DATA-MSYS-CLICKTRACK="0" REL="nofollow noopener noreferrer">SQL Connections</A>, <A HREF="http://www.sqlsaturday.com/" TARGET="_blank" DATA-MSYS-CLICKTRACK="0" REL="nofollow noopener noreferrer">SQL Saturday</A> events, and various user groups and webcasts. Tim is coauthor of the book <A HREF="http://www.amazon.com/SSIS-Design-Patterns-Matt-Masson/dp/1430237716/ref=sr_1_1?s=books&ie=UTF8&qid=1321147135&sr=1-1" TARGET="_blank" DATA-MSYS-CLICKTRACK="0" REL="nofollow noopener noreferrer">SSIS Design Patterns</A>, and is a contributing author on the charity book project <A HREF="http://www.amazon.com/SQL-Server-MVP-Deep-Dives/dp/1617290475/ref=sr_1_1?ie=UTF8&qid=1321143903&sr=8-1" TARGET="_blank" DATA-MSYS-CLICKTRACK="0" REL="nofollow noopener noreferrer">MVP Deep Dives 2</A>. He is an active group member and speaker at the <A HREF="http://northtexas.sqlpass.org/" TARGET="_blank" DATA-MSYS-CLICKTRACK="0" REL="nofollow noopener noreferrer">North Texas SQL Server User Group</A> in the Dallas area.
You can visit his website and blog at <A HREF="https://www.timmitchell.net/" TARGET="_blank" DATA-MSYS-CLICKTRACK="0" REL="nofollow noopener noreferrer">TimMitchell.net</A> or follow him on Twitter at<A HREF="http://twitter.com/tim_mitchell" TARGET="_blank" DATA-MSYS-CLICKTRACK="0" REL="nofollow noopener noreferrer">twitter.com/Tim_Mitchell</A>.