SQL Server Integration Services Course (SSIS)

Learn SQL Server Integration Services and Microsoft BI development of packages with our online SSIS Course.

Enrol in our SQL Server Integration Services Course to master data integration and ETL using Microsoft Business Intelligence tools. And note that this SSIS online video training is made for beginners as well as more experienced BI developers who master other technologies.

Discover the power of Microsoft’s leading ETL tool, through our in-depth SSIS lectures, with practical examples and SQL code. The exercises are explained step by step to allow smoother progress.

Enrol today to learn Data Integration with SSIS (SQL Server Integration Services)

SQL Server Integration Services Course - SSIS training full course on Udemy
SSIS Training Full Course (SQL Server Integration Services) on Udemy

Learn the essentials of creating and using DTSX packages for various data operations:

  • Loading flat files
  • Managing Excel files
  • Import and export of XML documents
  • Transferring data between databases using DTSX packages
  • And also exporting data and managing integration errors.

Practical Use Case in this SQL Server Integration Services Course

The courses are based on SQL Server 2019 and are gradually updated to the latest versions of MS SQL, i.e. SQL Server 2022. The current version is Microsoft SQL Server 2022.

At Expert-Only.com, we offer IT courses and tutorials for both beginners and seasoned professionals, including our 100% online SSIS training. Enhance your data engineering skills with Microsoft BI tools like SSIS, SSAS, SSRS, and Power BI, and stay ahead in the ever-evolving IT industry.

What is SQL Server Integration Services?

SQL Server Integration Services abbreviated as SSIS is an ETL, or data loading tool that can be used to copy and transform data from one location to another. SSIS is a very powerful and flexible tool that can be used for many different purposes.

Its main purpose is to load data into databases, or to transfer it from one data source to another. Here we use SQL Server database and tables as main sources and targets.

It can also extract, transform and load data from other sources such as flat files (CSV files, Excel files, etc.), but also different database vendors using specific connectors, like Oracle, Salesforce or SAP HANA for example.

It can also be used for tasks such as backing up data, copying data from one database to another or archiving logs. Technically, it is a feature of SQL Server that helps automate data-related processes from one system to another, and broadly, any scriptable task.

1. SQL Server Integration Services Course: introduction and environment set-up

Before we dive into the SSIS online training agenda, to learn about data integration and develop your first project, start by installing the Microsoft SQL Server BI development environment. In the next paragraph, we list the 3 necessary software packages.

  • Overview of the SSIS course
  • Introduction to BI and SSIS

1.1 Set up Integration Services development Environment on Windows

Indeed the first part of the introduction section is all about the development setup, a necessary step for data management and integration. All the software is free, you can download it on your Windows desktop, laptop or Server.

Check the minimum hardware and software requirements to be sure they are met by your machine specs.

1.2 Create basic SSIS packages

Then we learn SSIS package basics, how to create a solution, a project and a package with simple control flows and data flows. The main elements of a package are control flows and data flows. Typically having one or more sources and one or multiple targets.

SQL Server Integration Services Course to learn data integration with Microsoft BI Stack
SSIS Online Training to learn data integration using the Microsoft BI Stack

2. Import and export flat files with SSIS

In this section, these SSIS courses are all about flat file management in BI and DWH field (CSV or TXT for example). And especially the import of data from an external source to a database. In these examples, the target database is a MS SQL database.

3. Importing and exporting Excel files

4. Import and export XML documents

This SQL Server Integration Services training explains step by step how to deal with XML documents for import and export.

5. SQL Server Integration Services Course: manage logs, metadata, processes and errors

6. SSIS variables, configurations and deployments

  • About SSIS variables, configurations and SSIS deployments
  • SSIS Variables lecture – part 1
  • SSIS Variables lecture – part 2
  • Quiz on Building SSIS variables
  • How to update Visual Studio and the SSIS Projects extension?
  • Create SSIS configurations and deploy packages to SQL Server
  • Create and manage different environments using SSIS Catalog
  • Quiz on SSIS variables and configuration

7. Data transformations in our SQL Server Integration Services Course

8. ZIP and Unzip files and folders with SSIS

In this Integration Services training, you’ll also learn in a very practical way how to compress into archives, and extract files and folders from compressed files using SSIS without using any third-party software or licence.

9. Full end-to-end BI project with SSIS using real-life data

  • The end to end BI Project Presentation
  • Step 1: Create the ODS and the DWH databases
  • Step 2: Create the ODS tables and load all the static dimensions
  • Step 3: Load the Fuel Prices in the ODS tables
  • Step 3 solution
    • Part 1: Solution, Package and flat file connection
    • Part 2: Sequence, Loop and Data Flow
    • Part 3: Duplicate Work for Fuel Prices Without Taxes
  • Step 4: Load Exchange Rates in the ODS
  • About the DWH Database Structure
  • Step 5: Create the DWH tables
  • Step 6: Load the DWH Dimension tables using an SSIS package
    • Part 1: Create DWH Time dimension data flow
    • Part 2: Create DWH Currency and Country dimension data flows
  • Step 7: Develop Fact Fuel Prices DWH Package
  • Step 8: Develop Exchange Rates DWH Package

10. Training bonuses: SSAS Tabular and Power BI

  1. Install Analysis Services 2022 on Windows
  2. Install Analysis Services Projects on Visual Studio 2022
  3. Create the SSAS Tabular model, Import DWH tables and create relationships
  4. Create DAX Measures and Hierarchies
  5. Enrich Exchange Rates and Analyse the DWH data in Excel
  6. Deploy the Tabular Model or Import it using XMLA
  7. Fine Tuning the Tabular Model
  8. Download and Install Power BI Desktop
  9. Create a Power BI Report with Graphs

In the last 2 lectures, you’ll learn 10 tips based on real BI projects from an experienced BI and EPM Engineer and Consultant.

A final word on our SQL Server Integration Services Course

So, in conclusion to this SQL Server Integration Services course, it is a data integration tool that can be used to load data between heterogeneous systems. It can also extract, transform and load data from various sources, and perform tasks such as backing up data and archiving logs, amongst many others.

This video training and different sections provide a practical approach to learning SSIS, with examples and step-by-step instructions for setting up the development environment, creating and manipulating packages, and developing advanced SSIS projects.

Enrol today to learn Data Integration with SSIS (SQL Server Integration Services)

Learn ETL and data integration with SSIS on Udemy

This SSIS online training covers a wide range of topics, including importing and exporting data from flat files, Excel files and XML documents, and using SSIS for data aggregation and merging. But also how to build a tabular model based on a data warehouse project with real-life data.

These various lectures are aimed at both beginners and experienced IT professionals who want to improve their BI skills using the Microsoft BI stack.