Invalid quantity. Please enter a quantity of 1 or more.
The quantity you chose exceeds the quantity available.
Please enter your name.
Please enter an email address.
Please enter a valid email address.
Please enter your message or comments.
Please enter the code as shown on the image.
Please select the date you would like to attend.
Please enter an email address.
Please enter a valid email address in the To: field.
Please enter a subject for your message.
Please enter a message.
You can only send this invitations to 10 email addresses at a time.
$$$$ is not a properly formatted color. Please use the format #RRGGBB for all colors.
Please limit your message to $$$$ characters. There are currently ££££.
$$$$ is not a valid email address.
Please enter a promotional code.
N/A
Sold Out
You have exceeded the time limit and your reservation has been released.
The purpose of this time limit is to ensure that registration is available to as many people as possible. We apologize for the inconvenience.
This is option is not available anymore. Please choose a different option.
Please read and accept the waiver.
All fields marked with * are required.
Please double check your email address. The email address format does not appear valid.
$$$$ requires a number between ££££ and §§§§
US Zipcodes need to be 5 digits.
Please double check your website URL.
All fields marked with * are required.
Your credit card expiration date is in the past.
Your credit card CSC needs to be 4 digits.
Please confirm your order:
$$$$
You have selected to Pay by Check.
Click OK to confirm your order.
Please confirm your order:
$$$$
You have selected to Pay at the Door.
Click OK to confirm your order.
Please confirm your order:
$$$$
You have selected to Pay upon Receiving an Invoice.
Click OK to confirm your order.
Your credit card CSC needs to be 3 digits.
Your billing zip code needs to be 5 digits.
There was a problem saving your address.
There was a problem saving your credit card info.
There was a problem saving your personal information.
Please select the date you would like to attend.
McAfee Secure sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams.
Copying Prohibited by Law - McAfee Secure is a Trademark of McAfee, Inc.
Unknown card type.
No card number provided.
Credit card number is in invalid format.
Wrong card type or credit card number is invalid.
Credit card number has an inappropriate number of digits.
Please enter numbers here.
Please enter an integer value.
Numbers must be less or equal to $$$$
All the required fields have not been filled out. Click OK to proceed without all the required information, or click Cancel to finish entering the missing data.
Sorry, invalid event registration form.
Sorry, invalid event or database error.
Sorry, quantity must be a positive integer.
Sorry, you did not select a valid ticket.
Sorry, invalid event organizer email address.
Your order was canceled.
Thank You. Your order has been successfully completed. Your name and email address have been added to the list of event attendees.
Sorry, that option is sold out.
Sorry, that option is no longer available.
Sorry, there are only tickets of that type still available.
Sorry, you entered an invalid quantity. Please enter a quantity of 1 or more next to the type or types of tickets you would like to purchase.
Sorry, you did not select any tickets to purchase. Please enter a quantity of 1 or more next to the type or types of tickets you would like to purchase.
Sorry, there are no tickets left for this event.
The tickets, ticket quantity or date and time you've requested are no longer available, due to previous sales. Please choose a different date, time or number of tickets and place your order again.
Sorry, one or more of the tickets you requested are no longer available for purchase.
Sorry, you need to select the date you want to attend.
Sorry, the promotional code you entered is not valid yet.
Sorry, the promotional code you entered has expired.
Sorry, the promotional code you entered is not valid.
Your session has expired. Try ordering again.
Sorry, your requested ticket quantity exceeds the number provided by your promotional code.
Sorry, the tickets you are trying to order are not currently available.
Sorry, the payment type chosen is invalid for this event.
Sorry, there is only 1 ticket left for this event.
Sorry, there are only tickets left for this event.
We're sorry, this invitation is invalid.
We're sorry, this invitation has already been used.
We're sorry, you already have an order being processed for this event. Please wait a few minutes and try again.
We're sorry, there is a problem with your invitation. Please try again.
Invalid quantity of tickets selected.
Invalid donation amount.
Sorry, the payment type chosen is invalid for this event.
Sorry, your billing address was not saved properly, please try again.
Sorry, we experienced an internal error, please try again.
The captcha you entered is invalid. Please try again.
Invalid credit card selected. You have been logged out.
Sorry, your team selection was not valid.
Sorry, the payment type chosen is invalid for this event.
Sorry, your billing address was not saved properly, please try again.
Sorry, we experienced an internal error, please try again.
State
Zip Code
Province
Postal Code
County
State/Territory
State/Province
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
Lesson 1: Creating Your First SSIS package
Lesson 2: Introduction to the Data Flow Task
Lesson 3: The Control Flow
-
Containers, Precedence, and Work flow.
-
Transactions, restart-ability, and blocking.
Lesson 4: 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
Lesson 7: ETL Design Patterns
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.
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 (ET)
Add to my calendar
