Introduction to SSIS

$95.00

What Will You Learn?

  • How to create an SSIS package to load to a database
  • How to make dynamic packages that work and self-heal in the event of a failure
  • How to use SSIS in your environment

 

Description

This course is 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 with how the design and execution of environments work, and prepare you to build your own real world applications using this SQL Server application. Students will learn real world uses for SSIS.

Instructor

DEVIN KNIGHTDEVIN KNIGHT

Director of Training
Devin Knight is our Training Lead, overseeing our workshops, boot camps, virtual training, webinars and corporate training programs. Devin is a Microsoft Most Valued Professional (MVP) and has authored numerous technical publications, including the books “Knight’s 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services”, “Knight’s Microsoft Business Intelligence 24-Hour Trainer” and “SharePoint 2010 Business Intelligence 24-Hour Trainer”. He has been selected as a speaker for conferences like PASS, SQLSaturdays and Code Camps for many years, and is the President of the SQL Server user group in Jacksonville, Florida (JSSUG).

 

What to Know Before the Class

This course assumes that you have no previous knowledge of SSIS. In some of the scripting modules, it is useful (but not mandatory) that attendees have some Visual Basic experience. You will need to know how to run a query inside of SQL Server.


Duration: 7:43:02
This SSIS class is 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.
SSIS - What you need to get started
Module 00 - Getting Started
06:53
Module 01 - SQL Server Integration Services Overview
15:37
Module 02A - Introduction to the Development Environment (Introduction to SQL Server Data Tools)
25:31
Module 02B - Introduction to the Development Environment (Connection Managers)
16:54
Module 02C - Introduction to the Development Environment (Precedence Contraints and Control Flow Tasks)
31:12
Module 03A - Loading Data with the Data Flow (Common Sources)
24:54
Module 03B - Loading Data with the Data Flow (Common Transforms)
41:07
Module 03C - Loading Data with the Data Flow (Common Destinations)
31:21
Module 04A - Using Variables, Parameters and Expressions (Using Variable and Parameters)
15:41
Module 04B - Using Variables, Parameters and Expressions (SSIS Expression Language and Parameterized Objects)
21:35
Module 05A - Using Containers (Grouping, Sequence and For Loop Container)
18:20
Module 05B - Using Containers (For Each Loop Container)
24:33
Module 06 - Troubleshooting SSIS
15:54
Module 07A - Loading a Dimension (Designing a Data Warehouse)
36:31
Module 07B - Loading a Dimension (Loading Dimension Tables)
28:13
Module 08 - Loading a Fact Table
26:38
Module 09 - Deploying SSIS Packages
20:27
Module 10 - Configuring SSIS Packages for Portability
21:51
Module 11 - SSIS Server Executions
24:35
Module 12 - Setting Up Auditing and Notification
15:15
Class Survey

 

System Requirements

  • Microsoft Windows XP Professional, Microsoft Windows Server 2003, Microsoft Vista, Windows 7 or Windows 8
  • 1 GHz or faster CPU
  • 1 GB of available RAM (recommended 2 GB)
  • 20 GB of free hard drive space
  • SQL Server Developer, Standard or Enterprise Edition 2008/2008R2/2012/2014
  • AdventureWorks2008R2 or AdventureWorks2012 databases installed on the instance
  • AdventureWorksDW2008R2 or AdventureWorksDW2012 databases installed on the instance