Important note: The May 2026 delivery of this course will be based on SQL Server 2016. For training sessions scheduled after this date, the course content will be updated to SQL Server 2025.

This intensive course provides practical coverage of designing, developing, deploying, and operating SQL Server Integration Services (SSIS) solutions.

With a strong focus on enterprise SSIS environments, the course covers ETL (Extract, Transform, Load) processes used to extract information from source systems, transform data, and load it into target platforms. Participants will also work with data integration, file and data management, SSIS server administration, package execution, monitoring, and enterprise deployment practices.

Rather than focusing solely on creating SSIS packages, the training also examines how SSIS solutions can be designed, optimized, deployed, and managed for enterprise data integration and data warehousing scenarios.

What Will I Learn?

During this course, you will learn how to create and develop SSIS projects and packages and design SSIS solutions for different data integration requirements.

You will explore the use of SSIS for file and data management, data extraction and loading, and the implementation of ETL processes. The course also covers ETL techniques for dimension and fact tables together with loading and processing SSAS dimensions and cubes.

In addition, you will develop the skills required to deploy, configure, execute, monitor, and administer SSIS solutions in server and production environments.

We can organize this training at your preferred date and location.

Prerequisites

Basic experience with Business Intelligence solutions and SQL Server
Previous experience with SQL Server SSIS is not required

What You Will Learn

By the end of the course, participants will be able to:

Create and develop new SSIS projects and packages.
Use SSIS for file and data management processes.
Load SSAS dimensions and cubes.
Select an appropriate SSIS project and deployment approach.
Understand and apply ETL concepts within SSIS.
Deploy SSIS solutions to servers and manage their execution in production environments.

Training Outline

Module 1: SSIS Overview and Core Features

Introduction to Business Intelligence
Microsoft tools for BI
Introduction to data integration
Overview of SSIS features
Lab 01: SSIS Overview and Core Features

Module 2: Data Warehousing

Dimensional modeling
Optimizing a dimensional database
Preparing data for advanced analytics
Lab 02: Preparing a Data Warehouse

Module 3: SSIS Control Flow Objects and Features

Understanding Control Flow
Control Flow concepts
Control Flow objects
Control Flow features
Lab 03: Using Control Flow to Orchestrate SSIS Execution

Module 4: Extracting, Transforming, and Loading Data with SSIS Data Flows

The SSIS Data Flow Task
Data Flows and Data Paths
Data connections and Connection Managers
Data Flow components
Lab 04: Using SSIS Data Flows to Perform Data Movements

Module 5: Working with Files and Importing and Exporting File Data

Automating file system maintenance with SSIS
Extracting data from files
Loading data into files
Considerations when working with Excel
Lab 05: Working with Files in SSIS

Module 6: Optimizing Data Extraction and Loading

Fundamentals of data extraction optimization
Determining the "Delta"
Change Tracking
Change Data Capture (CDC)
Fundamentals of data loading optimization
Lab 06: Using Change Data Capture in SSIS Data Flows

Module 7: Data Quality and Cleansing

Data quality
Data profiling
Data Quality Services
Fuzzy Matching
Lab 07: Data Profiling and Cleansing

Module 8: Advanced Enterprise Information Management

Script Task and Script Component
Text mining
Advanced analytics and SSIS
Lab 08: Validating Data Using Regular Expressions

Module 9: Dimension ETL with SSIS

Dimension ETL theory
SQL Server Temporal Tables
SSIS Slowly Changing Dimension Wizard
Custom Dimension ETL
Lab 09: Dimension ETL with SSIS

Module 10: Fact ETL with SSIS

Fact Table ETL theory
Preparing data for fact tables
Advanced concepts
Lab 10: Fact ETL with SSIS

Module 11: Project Deployment Model – Execution and Reporting

Power Pivot
Power Query
Lab 11: Power Query

Module 12: Processing SSAS Objects with SSIS

SSAS Tabular and Multidimensional
Processing methods in SSIS
Dynamic processing and partition creation
Lab 12: Analysis Services Processing

Module 13: Project Deployment

Project Deployment Model
Deployment to the SSISDB Catalog
Administration, security, and configuration
Execution
Monitoring
The Master Package concept
Lab 13: SSIS Project Deployment, Configuration, Execution, and Monitoring

Module 14: Package Deployment

Package Deployment Model
Deployment to the SSIS Package Store
Administration, configuration, and security
Execution
Monitoring and logging
Lab 14: SSIS Package Deployment, Configuration, Execution, and Monitoring

Module 15: Transactions and Restartability

Using breakpoints in SSDT
Implementing transactions in SSIS
Using SQL Server Database Snapshots
Restartability of SSIS packages
Responding to events
Lab 15: Using Transactions and Checkpoints in SSIS Packages

Module 16: Optimization and Scalability

Leveraging SSIS and Transact-SQL
Understanding Data Flow Engine internals
SSIS optimization techniques
SSIS performance troubleshooting
Lab 16: Optimizing SSIS Packages for Performance

Why Choose Us

Experience Accelerated SQL Server Integration Services in Saudi Arabia through Bilginç IT Academy's live and interactive virtual classroom environment. Join a Public course as an individual delegate or arrange a dedicated Private / In-house online training program exclusively for your organization.

Delivery Method: Online Instructor-Led
Participation Model: Public / Private (In-house)
Live and Interactive Training: Connect with your instructor in real time and actively participate through discussions, Q&A sessions, practical exercises, and group activities.
Flexible Participation: Join the training from your home, office, or any location with a suitable internet connection.
Expert Trainer Network: Learn from experienced trainers with strong industry backgrounds and practical field expertise.
Over 30 Years of Training Expertise: Benefit from Bilginç IT Academy's professional training experience since 1995.
Worldwide Access: Join our live virtual classrooms from Saudi Arabia or anywhere else in the world, or arrange a dedicated online training program for your organization.

Experience Accelerated SQL Server Integration Services through face-to-face Classroom Based training in Saudi Arabia. Training can be delivered as a Public course open to individual delegates or as a dedicated Private / In-house class for your organization.

Delivery Method: Classroom Based
Participation Model: Public / Private (In-house)
Face-to-Face Learning: Interact directly with your instructor and fellow delegates in an engaging classroom environment.
Experienced Trainers: Learn from specialists with extensive industry experience and practical real-world knowledge.
Professional Training Environment: Attend training in comfortable, well-equipped classrooms designed to support effective learning.
Practical Learning: Depending on the course, reinforce your knowledge through hands-on exercises, scenarios, case studies, and instructor-led activities.

Arrange Accelerated SQL Server Integration Services in Saudi Arabia as a dedicated Onsite training program for your organization. Bilginç IT Academy trainers can deliver the training at your office or another location of your choice, with the program planned around your team's requirements and business objectives.

Delivery Method: Onsite
Participation Model: Private (In-house)
Training at Your Preferred Location: Organize the training at your company's office or another location selected by your organization.
Tailored Course Content: Adapt the training program to your projects, team structure, existing skill levels, and specific business requirements.
Team-Focused Learning: Develop your team around a shared knowledge base while strengthening internal collaboration and knowledge transfer.
Flexible Scheduling: Plan the training dates, location, and program according to your organization's operational requirements.
Worldwide Onsite Delivery: Arrange the training in Saudi Arabia or at another preferred location worldwide. Bilginç IT Academy trainers can travel to your selected location to deliver the dedicated training program.

Why have you chosen us?

I have attended a training from Bilginc IT Academy before and I was satisfied.

I have attended a training from a different provider and it was not helpful.

Other

How many employees do you have in your IT department?

0 – 50

50 – 250

250 – 1000

1000+

Accelerated SQL Server Integration Services Training in Saudi Arabia

What Will I Learn?

Prerequisites

What You Will Learn

Training Outline

Module 1: SSIS Overview and Core Features

Module 2: Data Warehousing

Module 3: SSIS Control Flow Objects and Features

Module 4: Extracting, Transforming, and Loading Data with SSIS Data Flows

Module 5: Working with Files and Importing and Exporting File Data

Module 6: Optimizing Data Extraction and Loading

Module 7: Data Quality and Cleansing

Module 8: Advanced Enterprise Information Management

Module 9: Dimension ETL with SSIS

Module 10: Fact ETL with SSIS

Module 11: Project Deployment Model – Execution and Reporting

Module 12: Processing SSAS Objects with SSIS

Module 13: Project Deployment

Module 14: Package Deployment

Module 15: Transactions and Restartability

Module 16: Optimization and Scalability

Why Choose Us

Accelerated SQL Server Integration Services Training Course in Saudi Arabia Schedule

Accelerated SQL Server Integration Services Training in Saudi Arabia

What Will I Learn?

Prerequisites

What You Will Learn

Training Outline

Module 1: SSIS Overview and Core Features

Module 2: Data Warehousing

Module 3: SSIS Control Flow Objects and Features

Module 4: Extracting, Transforming, and Loading Data with SSIS Data Flows

Module 5: Working with Files and Importing and Exporting File Data

Module 6: Optimizing Data Extraction and Loading

Module 7: Data Quality and Cleansing

Module 8: Advanced Enterprise Information Management

Module 9: Dimension ETL with SSIS

Module 10: Fact ETL with SSIS

Module 11: Project Deployment Model – Execution and Reporting

Module 12: Processing SSAS Objects with SSIS

Module 13: Project Deployment

Module 14: Package Deployment

Module 15: Transactions and Restartability

Module 16: Optimization and Scalability

Why Choose Us

Online Instructor-Led Training

Classroom Based Training

Onsite Training

Accelerated SQL Server Integration Services Training Course in Saudi Arabia Schedule