3.1. Hands-on Lab Preset

II. Configuration

• We will be using data from the AdventureWorks sample database which ships with SQL Server 2005.

3. Hands-on Lab I (Short data trouble shooting package)

I. Purpose of Hands-on Lab

• The purpose of this lab is to provide a quick sample/best practice on how to trouble shoot data within a package flow and to address common questions on ‘how to breakpoint and step through data in the flow’. We will load a contact table as the source data and parse out a portion of the email field, viewing the data to insure our parse expression is correct before connecting any ‘real’ destinations.
• This exercise will be more detailed than others on exactly what to click and type as a form of introduction, while the other labs will have more generalized instructions.
• This lab will also allow us to gauge the overall pre-knowledge of the students.