Pragmatic SSIS (Online)
4 Half Days
- SSIS Features In-depth
- Making your Package Dynamic
- Data Warehousing
- Deployment and Administration
Training Course Sections
06/24/13 - 06/27/13
2:00 PM - 5:00 PM EST
08/12/13 - 08/15/13
9:00 AM - 12:00 PM EST
Training Course Overview
A four half day class designed to help you understand all aspects of SQL Server Integration Services (SSIS), the ETL tool of choice for SQL Server users. We will use a variety of lab exercises and small projects to ensure you gain familiarity in how the design and execution environments work and be prepared to build your own real world applications using this SQL Server application. Students will learn how to use SSIS in the real-world. With the hands-on labs, you will learn how to create a SSIS package to load a database. You’ll also learn how to make the package dynamic to where it will work and self-heal in the event of a failure. This course gives detailed and extensive demos on how to use SSIS in your environment.
IMPORTANT: When you purchase a seat in this class you also receive 2 hours of our BI Virtual Mentor service for assistance with YOUR project work. This remote service lets you work ONE on ONE with our BI mentors to accelerate YOUR project and further improve YOUR skills. Your Virtual Mentor hours can be used during business hours anytime during the 12 months following your class. To set up a session, download this simple questionaire, fill it out, and send it as an attachment to email@example.com. This unique Pragmatic Works offering insures that your training will translate into real world success for YOUR projects.
Training Course Prerequisites
The target audiences of this class are developers, architects or IT professionals who have basic SQL skills. This class assumes that you have no previous knowledge of SSIS. In some of the scripting chapters, it is useful (but not mandatory) that the student has some basic VB experience. You will need to know how to run a query inside of SQL Server.
- Microsoft Windows Server 2008 SP2, Microsoft Windows Server 2008 R2 SP1, Windows Vista SP2, Windows 7 SP1
- 1 GHz or faster CPU
- 1 GB of available RAM (recommended 2 GB)
- 20 GB of free hard drive space
- SQL Server 2005/2008/2008R2/2012 with the client tools.
- AdventureWorks 2008 or 2012 and AdventureWorksDW 2008 or 2012 databases installed on the instance from http://msftdbprodsamples.codeplex.com/releases/view/55330
Terms & Conditions
A class recording will be available via the web for a limited time for students who missed a session. Recordings are copyright protected and may not be distributed to others.
One Student Per Seat
We limit the number of students in each class to maintain a proper student to instructor ratio. Each purchased seat in a Virtual Training class is for use by one student only.
Students must provide at least 14 days’ notice to reschedule or withdraw from a class. In the case of withdrawal a credit will be issued for another Virtual Training class of similar value. Cancellation/reschedule with less than 14 days’ notice is subject to a fee of 100% of the total price.
We reserve the right to cancel or reschedule a class up to 2 weeks prior to the start date. Any students in a cancelled or rescheduled class have the option of a refund or credit to be used for another Virtual Training class of similar value.
Training Course Outline
Day 1 - SSIS Features In-depth
- Intro to SSDT and the Control Flow
- SQL Server Data Tools (SSDT) Intro
- Connection Managers
- Precedence Constraints
- Common Tasks
- Loading with the Data Flow
- Common Sources
- Common Transforms
- Common Destinations
- Using Containers
- For Loop
- For Each Loop
Day 2 - Making your Package Dynamic
- Parameters, Expressions, and Variables
- Using Project and Package Parameters
- The expression language in SSIS
- Parameterized Connections
- Using Parameters, variables, and expressions to make a package dynamic
- Troubleshooting SSIS
- Diagnosing a package error
- Viewing Data in flight
- Creating Breakpoints
- The Script Task and Transform
- Handling Script Variables
- Script Tasks in the Control Flow
- Script Transforms in the Data Flow
Day 3 - Data Warehousing
- Loading a Dimension
- Data Warehouse Modeling
- Loading a dimension
- Loading a Fact Table
- Loading a fact table
- Tactics for quickly loading fact tables
- Configuring SSIS Packages with Configuration Files
- Using configuration files to externalize configurations
- Using tables to externalize configurations
Day 4 - Deployment and Administration
- Deploying SSIS
- Package vs. Project Deployment
- SSIS Catalog
- Security in SSIS
- Scheduling a package
- SSIS Server Executions
- Using the SSIS Catalog GUI
- Using the SSIS Catalog GUI
- Using T-SQL with SSIS
- Altering Parameters with T-SQL
- Setting Environments
- Event Handling and Logging in SSIS
- Event Handlers
- SSIS Reports
- Data Taps
Topics that will be covered if there is time
- Checkpoints and Transactions
- Migration from SQL Server 2000 DTS to SSIS
- Advanced Transforms
- Command line utilities and PowerShell
- Will I be able to ask the instructor a question? Of course! You are encouraged to participate in the class by asking questions and sharing your own case studies.
- How large is each class? Each class has a maximum capacity of 20-24 seats each month, they do fill up quickly.
- How would I receive individual attention? During the class, the conference line opens 30 minutes prior to the class to answer individual questions. If you still need more help, individual sessions can be scheduled during the week of the class for class-related questions.
- How much time is required of me to take this class? Each class is 4 hours a day so you’ll still have time to answer your emails or go to a meeting or two. To get the most out of the class, it’s extremely important to do the class labs so you can ask questions if you have problems.
- What if I miss a class? Each class is recorded and posted 24 hours after the class. The recording can be downloaded for up to 30 days after the class.
- Is the number a toll free number? GoToMeeting supports Voice of IP (VOIP) or a toll number. It is recommended that you have a speaker phone if you dial in, or use a head set for your comfort if you use VOIP. It is also recommended that if you can, have a second monitor so you can participate in a lab on one screen while the web meeting is happening on another.