Implementing and Maintaining Microsoft SQL Server Integration Services training, teaches students how to implement SQL Server Integration Services solution for extracting, transforming, and loading data. Students learn how to develop, deploy, and manage Integration Services packages.

Target Audience

This 3-day course is intended for information technology (IT) professionals and developers who need to implement data transfer or extract, transform, and load (ETL) solutions by using Microsoft SQL Server Integration Services.

Pre-requisites

Before attending this course, students must have:

  • Exposure to enterprise data import and export scenarios.
  • Experience navigating the Microsoft Windows Server environment.
  • Experience with Microsoft SQL Server, including: SQL Server Agent.SQL query language fundamentals (SELECT, UPDATE, INSERT, and DELETE).SQL Server System tables.SQL Server accounts (users and permissions).

Topics

Module 1: Introduction to SQL Server Integration Services

  • Overview of SQL Server Integration Services
  • Using Integration Services Tools

Module 2. Developing Integration Services Solutions

  • Creating an Integration Services Solution
  • Using Variables
  • Building and Running a Solution

Module 3: Implementing Control Flow

  • Control Flow Tasks
  • Control Flow Precedent Constraints
  • Control Flow Containers

Module 4: Implementing Data Flow

  • Data Flow Sources and Destinations
  • Basic Data Flow Transformations
  • Advanced Data Flow Transformations
  • Data Flow Paths

Module 5: Implementing Logging

  • Overview of Integration Services Logging
  • Enabling and Configuring Logging

Module 6: Debugging and Error Handling

  • Debugging a Package
  • Implementing Error Handling

Module 7: Implementing Checkpoints and Transactions

  • Checkpoints
  • Implementing Transactions

Module 8: Configuring and Deploying Packages

  • Package Configurations
  • Deploying Packages
  • Managing and Securing Packages
  • Managing Packages
  • Securing Packages