Skip Main Navigation
Page Content
This event has ended

A Day of SSIS with Andy Leonard and Matt Masson

Atlanta MDF

Friday, April 13, 2012 from 9:00 AM to 5:00 PM (EDT)

A Day of SSIS with Andy Leonard and Matt Masson

Ticket Information

Ticket Type Remaining Sales End Price Fee Quantity
Early Bird Sold Out Ended $99.00 $6.44
Regular Bird Sold Out Ended $109.00 $6.99

Share A Day of SSIS with Andy Leonard and Matt Masson

Event Details

A Day of SSIS

Learning SQL Server Integration Services

Sold OUT  !  Join the WAITLIST.

Training Description

A Day of SSIS was developed by Andy Leonard to train technology professionals in the fine art of using SQL Server Integration Services (SSIS) to build data integration and Extract-Transform-Load (ETL) solutions.

The training is focused around lectures and emphasizes a practical approach.

 Target Audience

 The target audience for this training is database professionals, application developers, and business intelligence practitioners interested in acquiring or expanding their existing SSIS skill set.

Prerequisites

No experience with SQL Server or SQL Server Integration Services is required before attending this training.

It is helpful (but not required) that students possess some knowledge of and experience with relational databases. SQL Server knowledge / experience will be more helpful than experience and knowledge with other technologies.

Training Objectives

At the conclusion of the training, attendees will have been exposed to:

  • Using SSIS to develop data integration solutions.
  • Using SSIS to load a database table.
  • Troubleshooting real-world SSIS Data Flow Task errors.
  • Deploying SSIS Solutions.
  • Managing, monitoring, and administering SSIS in the enterprise.

Training Summary

Lesson 0: Introduction

  • Training overview, expectations, and introductions.

Lesson 1: Creating Your First SSIS package

  • Introduction to Business Intelligence Development Studio. Visual Studio tips and tricks, menu contents and locations.

Lesson 2: Introduction to the Data Flow Task

  • Introduction to the Data Flow Task. Connection Manager and Data Flow Task basics - source and destination adapters.

Lesson 3: The Control Flow

  • Containers, Precedence, and Work flow.
  • Transactions, restart-ability, and blocking.

Lesson 4: Loop Containers

  • Using Sequence, For Loop, and Foreach Loop Containers.

Lesson 5: Event Handlers, Logging, and Configurations

  • The OnError and OnInformation event handlers.
  • Using SSIS’s built-in logging facility to capture package execution details and statistics.
  • Using built-in package configurations to externalize variable values.

Lesson 6: Security, Deployment, and Execution

  • SSIS Package deployment options and security implications.
  • Execution options.

Lesson 7: ETL Design Patterns

  • Leveraging less-documented features of SSIS along with the Parent-Child design pattern to achieve “hands-free” custom logging and creative custom configuration. ETL Instrumentation.

Lesson 8: Enterprise Execution Patterns

  • Leveraging the Parent-Child design pattern to build a metadata-driven SSIS execution engine
     

Lesson 9: SSIS Data Flow Internals (featuring Matt Masson)  NEW

Need a fast data integration solution, but don't have the time or budget for heavy performance tuning? By selecting the right design, 90% of SSIS customers will achieve their ETL performance goals with little to no performance tuning. This session will teach you how to pick that design! Targeted at intermediate to advanced SSIS users, Matt Masson (a developer on the SSIS team) and John Welch (SQL MVP) will guide you through a series of proven SSIS design patterns, and teach you how to apply them to solve many common ETL problems. We’ll start off with an overview of the Data Flow internals, and review the SQLCAT team’s Top Ten Best Practices for achieving optimal performance. We’ll then dive into a series of design patterns, including Advanced Lookup Patterns, Parallel Processing, Avoiding Transactions, handling Late Arriving Facts and multiple ways to process Slowly Changing Dimensions.

 

 

Why Train with Andy Leonard and Matt Masson?

.Andy is an author with decades of ETL experience and years of SQL Server Integration Services experience.

Andy is a professional trainer and mentor, and is passionate about SSIS.
He regularly provides advice and free instruction at his blog at SQLBlog.com and on Twitter (@AndyLeonard). When respected members of the SQL Server community have SSIS questions, they seek out Andy Leonard.



Matt Masson is a Senior Software Development Engineer working with the SQL Server Integration Services (SSIS) team. Matt has worked on many aspects of the SSIS product including upgrade, performance, and overall user experience. He is a frequent presenter at Microsoft conferences, and maintains an SSIS blog at http://www.mattmasson.com. He currently lives in Montreal, Quebec, and works remotely with his Redmond-based team.

Have questions about A Day of SSIS with Andy Leonard and Matt Masson? Contact Atlanta MDF

When & Where


Georgia State University- Alpharetta Center
3775 Brookside Parkway
Alpharetta, GA 30022

Friday, April 13, 2012 from 9:00 AM to 5:00 PM (EDT)


  Add to my calendar

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.