More results...

Generic filters
Filter by Brands/Technologies

55321 SQL Server Integration Services

On‑Demand: $595 | Instructor‑Led: $2,995 | Duration: 5 Days

Upgrade your tech skills with this , training course from TechSherpas 365!

Select a Learning Method Below

Start Date End Date CLASS TIMES (EST) DELIVERY/LOCATION Status Price Enroll Now
3/30/2026 4/3/2026
9:00AM - 5:00PM
star GTR

Guaranteed-to-Run
$2,995
7/27/2026 7/31/2026
9:00AM - 5:00PM
star GTR

Guaranteed-to-Run
$2,995
START DATE : 3/30/2026
END DATE : 4/3/2026
CLASS TIMES (EST) : 9:00AM - 5:00PM
DELIVERY/LOCATION :
STATUS :
star GTR

Guaranteed-to-Run
PRICE : $2,995
START DATE : 7/27/2026
END DATE : 7/31/2026
CLASS TIMES (EST) : 9:00AM - 5:00PM
DELIVERY/LOCATION :
STATUS :
star GTR

Guaranteed-to-Run
PRICE : $2,995

Course Highlights

LEVEL: 
  • Intermediate
TOPICS & JOB ROLES: 
BRANDS/TECHNOLOGIES: 

55321 SQL Server Integration Services Course Outline

SQL Server Integration Services is the Community Courseware version of 20767CC Implementing a SQL Data Warehouse. This five-day instructor-led 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.

Who Should Attend this Course?

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.

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.

1 – SSIS Overview

  • Import/Export Wizard
  • Exporting Data with the Wizard
  • Common Import Concerns
  • Quality Checking Imported/Exported Data

2 – Working with Solutions and Projects

  • Working with SQL Server Data Tools
  • Understanding Solutions and Projects
  • Working with the Visual Studio Interface

3 – Basic Control Flow

  • Working with Tasks
  • Understanding Precedence Constraints
  • Annotating Packages
  • Grouping Tasks
  • Package and Task Properties
  • Connection Managers
  • Favorite Tasks

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 – 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 – Data Flow Transformations

  • Transformations
  • Configuring Transformations

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 – Containers

  • Sequence Containers
  • For Loop Containers
  • Foreach Loop Containers

9 – Troubleshooting and Package Reliability

  • Understanding MaximumErrorCount
  • Breakpoints
  • Redirecting Error Rows
  • Logging
  • Event Handlers
  • Using Checkpoints
  • Transactions

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 – 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 – Securing the SSIS Catalog

  • Principals
  • Securables
  • Grantable Permissions
  • Granting Permissions
  • Configuring Proxy Accounts

Related Job Roles

This course builds skills and demonstrates qualifications for the job roles and average base salaries below. 

Market Intelligence Analyst

Demographer

Education Research Analyst

Mathematical Statistician

Psychometric Consultant

Quantitative Methodologist

Explore Related Training Courses

Related products

  • Data & Analytics

    PL-900T00 Microsoft Power Platform Fundamentals
    Microsoft Technical
    Beginner
    Learn the business value and product capabilities of Microsoft Power Platform. Create simple Power Apps, connect data with Dataverse, build a Power BI Dashboard, and automate processes with Power Automate.
    1 Day(s)
    $295 - $1,295
    Classroom Live
    On-Demand Learning (ODL)
    Virtual Classroom
    Live, Instructor-Led (ILT)
  • Business Intelligence

    Power BI for Data-driven Decision Makers
    Microsoft Technical
    Intermediate
    As data acquisition, access, analysis, and reporting are interwoven with our businesses and lives, more and more data is collected about business and personal activities. This abundance of data and…
    1 Day(s)
    $395
    Virtual Classroom
    Live, Instructor-Led (ILT)
  • Data & Analytics

    SQL Querying Fundamentals – Part 1
    Microsoft Technical
    Beginner
    In this course, students will compose SQL queries to retrieve desired information from a database.
    1 Day(s)
    $695
    Virtual Classroom
    Live, Instructor-Led (ILT)
  • Data & Analytics

    SQL Querying Fundamentals – Part 2
    Microsoft Technical
    Intermediate
    In this course, students will work with advanced queries to manipulate and index tables. Students will also create transactions so that you can choose to save or cancel data entry…
    1 Day(s)
    $695
    Virtual Classroom
    Live, Instructor-Led (ILT)

What Our Students Are Saying

IT Certification Training Course Reviews