Course MOC 55321AC: SQL Server Integration Services

ExistBI is a Microsoft Partner

Course Description

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.

Course Outcomes

At the end of the course, learners will be able to:

  • Describe core administration tasks and tools
  • Configure the Informatica Administrator tool
  • Create and configure necessary services
  • Manage Informatica security
  • Audit security access and privileges
  • Perform ongoing maintenance
  • Stop or recycle a service
  • Review domain logs

Course Summary

Next Public Course Dates

UK & Europe:

  • 17 - 21 November 2025
  • 1 - 5 December 2025
  • 15 - 19 December 2025

US & Canada:

  • 8 - 12 December 2025
  • 12 - 16 January 2026
  • 26 - 30 January 2026

More dates

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.
Duration
  • 5 Days
Available Formats
  • Public Virtual Live Instructor-Led
  • Private Virtual Live Instructor-Led
  • Private Onsite

Course Modules

Course Topics
  • SSIS Overview
  • Working with Solutions and Projects
  • Basic Control Flow
  • Common Tasks
  • Data Flow Sources and Destinations
  • Data Flow Transformations
  • Making Packages Dynamic

Containers

  • Troubleshooting and Package Reliability
  • Deploying to the SSIS Catalog
  • Installing and Administering SSIS
  • Securing the SSIS Catalog

Testimonials

Absolutely loved the enthusiasm and appreciate the knowledge he brought to class!!!

★★★★★

- Shelly Fruits, KPERS

The course was comprehensive and interactive, and the trainer really understood the content. I have been able to implement much of what I learned into my daily work activities and have saved a lot of time.

★★★★★

- Susan Medina, Advocate Health Care

Thoroughly enjoyed the training. The trainer was fantastic! It is rare but always an awesome experience when a trainer is also an experienced practioner with a breadth of knowledge and hands on experience… even well beyond the subject matter at hand. I had the feeling that the trainer could have answered in detail any question we might have had related to not only BDM but Hadoop and other relevant big data topics as well. Time well spent and I hope to encounter Tomi again.

★★★★★

- Rick Kirk, CTO, Alliant Energy / Ernst & Young

Upcoming Public Virtual Live Instructor-led Course Dates

UK & Europe:

US & Canada:

    To discuss your project requirements, send us a message

      For a free assessment, quick quote or training information, send us a message

        To book this course, please fill in your details and submit the form.

          To book this course, please fill in your details and submit the form.

            To discuss your training requirements or book a class, drop us a line