$129

Building Better SSIS Packages

Event Information

Share this event

Date and Time

Location

Location

Hilton Garden Inn Pensacola Airport

1144 Airport Boulevard

Pensacola, FL 32504

View Map

Friends Who Are Going
Event description

Description

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:

  • 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.

Share with friends

Date and Time

Location

Hilton Garden Inn Pensacola Airport

1144 Airport Boulevard

Pensacola, FL 32504

View Map

Save This Event

Event Saved