This course is intended for IT professionals who need to learn how to use SSIS to build, deploy, maintain, and secure Integration Services projects and packages, and to use SSIS to extract, transform, and load data to and from SQL Server. This course is similar to the retired Course 20767-C: Implementing a SQL Data Warehouse but focuses more on building packages, rather than the entire data warehouse design and implementation.

starstarstarstarstar_outline

* Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Learning Objectives

After completing this course, you will be able to:
Create sophisticated SSIS packages for extracting, transforming, and loading data
Use containers to efficiently control repetitive tasks and transactions
Configure packages to dynamically adapt to environment changes
Use Data Quality Services to cleanse data
Successfully troubleshoot packages
Create and Manage the SSIS Catalog
Deploy, configure, and schedule packages
Secure the SSIS Catalog

1
  • MODULE 1: SSIS OVERVIEW

  • Import/Export Wizard

    Exporting Data with the Wizard

    Common Import Concerns

    Quality Checking Imported/Exported Data


2
  • MODULE 2: WORKING WITH SOLUTIONS AND PROJECTS

  • Working with SQL Server Data Tools

    Understanding Solutions and Projects

    Working with the Visual Studio Interface


3
  • MODULE 3: BASIC CONTROL FLOW

  • Working with Tasks

    Understanding Precedence Constraints

    Annotating Packages

    Grouping Tasks

    Package and Task Properties

    Connection Managers

    Favorite Tasks


4
  • MODULE 4: COMMON TASKS

  • Analysis Services Processing

    Data Profiling Task

    Execute Package Task

    Execute Process Task

    Expression Task

    File System Task

    FTP Task

    Hadoop Task

    Script Task Introduction

    Send Mail Task

    Web Service Task

    XML Task


5
  • MODULE 5: DATA FLOW SOURCES AND DESTINATIONS

  • The Data Flow Task

    The Data Flow SSIS Toolbox

    Working with Data Sources

    SSIS Data Sources

    Working with Data Destinations

    SSIS Data Destinations


6
  • MODULE 6: DATA FLOW TRANSFORMATIONS

  • Transformations

    Configuring Transformations


7
  • MODULE 7: MAKING PACKAGES DYNAMIC

  • Features for Making Packages Dynamic

    Package Parameters

    Project Parameters

    Variables

    SQL Parameters

    Expressions in Tasks

    Expressions in Connection Managers

    After Deployment

    How It All Fits Together


8
  • MODULE 8: CONTAINERS

  • Sequence Containers

    For Loop Containers

    Foreach Loop Containers


9
  • MODULE 9: TROUBLESHOOTING AND PACKAGE RELIABILITY

  • Understanding MaximumErrorCount

    Breakpoints

    Redirecting Error Rows

    Logging

    Event Handlers

    Using Checkpoints

    Transactions


10
  • MODULE 10: DEPLOYING TO THE SSIS CATALOG

  • The SSIS Catalog

    Deploying Projects

    Working with Environments

    Executing Packages in SSMS

    Executing Packages from the Command Line

    Deployment Model Differences


11
  • MODULE 11: INSTALLING AND ADMINISTERING SSIS

  • Installing SSIS

    Upgrading SSIS

    Managing the SSIS Catalog

    Viewing Built-in SSIS Reports

    Managing SSIS Logging and Operation Histories

    Automating Package Execution


12
  • MODULE 12: SECURING THE SSIS CATALOG

  • Principals

    Securables

    Grantable Permissions

    Granting Permissions

    Configuring Proxy Accounts


Audience

The primary audience for this course is database professionals who need to fulfil a Business Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing.

Language

English

Prerequisites

Working knowledge of T-SQL and SQL Server Agent jobs is helpful, but not required. Basic knowledge of the Microsoft Windows operating system and its core functionality. Working knowledge of relational databases. Some experience with database design.

$3,275

Length: 5.0 days (40 hours)

Level:

Not Your Location? Change

Course Schedule:

Schedule select
25
Sep
Monday
8:00 AM PT -
4:00 PM PT
Available
Loading...