Introduction to SQL Server Integration Services (SSIS)

Name: Introduction to SQL Server Integration Services (SSIS)
Rating: 4.2 (116 reviews)

Master Microsoft's SSIS basics and transform your data management skills with database and ETL process automation.

Created bySimon Sez IT

Last updated 12/2025

English

English [Auto],

What you'll learn

Explain the purpose and real-world applications of SQL Server Integration Services (SSIS).
Navigate the SSIS interface, including using the SSIS Toolbox and Solutions Explorer.
Create control flow structures in SSIS packages to manage tasks efficiently.
Manage data transformation using different components in the Data Flow section.
Construct SSIS expressions, including string functions, to manipulate data.
Utilize mathematical functions and data conversion transformations for ETL processes.
Implement various SSIS transformations to aggregate, merge, and modify data.
Combine data from multiple sources using Union All, Merge, and Merge Join transformations.
Perform data lookups and understand the options for SSIS Lookup cache modes.
Set up and use parameters at both project and package levels, and handle errors efficiently in your SSIS packages.

Course content

5 sections • 24 lectures • 3h 34m total length

Introduction1:39
Explore SQL Server Integration Services (SSIS), a fast data warehousing tool for migration, ETL, archiving, loading, cleansing, and history management. Navigate control flow, data flow, expressions, and deployment.
WATCH ME: Essential Information for a Successful Training Experience2:11
Watch this video to learn essential information for the training, including downloadable exercise files and instructor files. Unzip the files and adjust playback as needed.
DOWNLOAD ME: Exercise Files0:23
DOWNLOAD ME: Course Files0:23
What is SSIS?9:32
Explore etl concepts and how ssis enables extracting, transforming, and loading data from diverse sources into a data warehouse, with data cleansing, bulk loading, and history management.
Navigating SSIS11:59
Explore the ssis interface, including the toolbox, solutions explorer, and designer, and learn to build a basic etl package that reads from a flat file and loads into sql server.
Control Flow6:56
Explore how the control flow orchestrates SSIS packages by managing executables, serial or parallel execution, and precedence constraints to direct data flow and SQL execution.
Data Flow8:59
Explore the data flow in SSIS, transforming and routing data from sources to destinations using common transformations like aggregate, sort, lookup, and merge join for ETL, culminating in loaded outputs.
Section Quiz

SSIS Expressions Part 111:05
Explore SSIS expressions, which combine symbols, literals, functions, and operators to yield values. Apply them in conditional splits, derived columns, and variables, using trim, upper, and date part.
SSIS Expressions Part 210:52
Master SSIS expressions in a data flow by using derived columns for round, ceiling, floor, and abs with an Excel source and data conversion to double.
Data Transformation Part 111:10
SQL Server Integration Services (SSIS) transformations in the data flow, including row, aggregate, sort, join, and audit operations, with a hands-on example using the Superstore Sales Excel file.
Data Transformation Part 211:15
Learn to transform data in SSIS using union all to append two flat files, then sort, merge, and finally join datasets with a merge join to produce a consolidated output.
Data Transformation Part 311:20
Learn to use the lookup transformation in SSIS to join data with a reference table, configure cache modes and non-matching row handling, and pivot and aggregate to show category totals.
Section Quiz

Parameters7:58
Learn how SSIS parameters extend scope by passing runtime values to project and package properties, then map project parameters to connection managers for dynamic ETL.
Error Handling11:17
Learn SSIS error handling for ETL, including data conversion, expression evaluation, and lookup errors, using component-level and event handler approaches with error redirection and SQL logging.
Looping Part 19:45
Use a for each loop container in ssis to iterate through dept-trans-*.csv files in a folder, dynamically configure a flat file source, and load data into the dept_transactions table.
Looping Part 29:20
Looping part 2 demonstrates using the for loop container in SSIS to process Superstore_transactions by category code, exporting each code to its own csv file with dynamic naming.
Deployment and Scheduling9:00
Deploy SSIS projects by creating the SSIS DB catalog, deploying via the Deployment Wizard, and scheduling runs with SQL Server Agent, managing packages, environments, and parameters.
Section Quiz

Exercise 12:54
Build an SSIS package with a data flow that reads trainee table using an OLE DB source, aggregates by education_level, counts distinct Rollie_ID values, and outputs CSV file with headers.
Exercise 26:57
Build an SSIS package to merge orders, bikes, and shops from Excel using bike ID and bike shop ID, derive sales, and aggregate by shop name, model, and total sales.
Exercise 34:08
Execute a foreach loop to process five acc* csv files, loading each into a sql table via a data flow with a flat file source and an ole db destination.
Course Close0:40
Explore SSIS basics, including control flow and data flow functions, expressions, transformations, parameters, and containers, plus deployment, scheduling, and SQL Server Agent.

Requirements

No prior SSIS knowledge required. This course is suitable for beginners.

Description

**This course includes downloadable exercise files to work with**

Embark on a transformative journey with our Introduction to SQL Server Integration Services (SSIS) beginner course. This course is your gateway to mastering Microsoft's SSIS, a powerful tool for data extraction, transformation, and loading (ETL).

You'll discover how to navigate the tool effortlessly, explore the control and data flow functions, and build a strong foundation in Expressions and Transformations, the building blocks of SSIS workflows. Learn to handle Parameters, troubleshoot errors effectively, and understand how Looping functions enhance automation. In the final session, you'll unlock the art of deploying your packages into the SSISDB catalog, taking your newfound skills to the next level.

Throughout the course, you'll grasp the essentials of SSIS, from using the SQL Server Business Intelligence Development Studio to the practical applications of SSIS in real-world scenarios. With an in-depth look at the SSIS Toolbox, Solutions Explorer, and Properties Window, you'll easily navigate SSIS. You'll also delve into the Control Flow, Data Flow, SSIS Expressions, and Transformations, gaining a comprehensive understanding of each component's role and functionality.

By the end of this course, you'll be equipped with the knowledge and skills to help you excel in using SSIS for automating SQL Server database maintenance and ETL processes. Whether you aim to enhance your career prospects or streamline data management, this course will help empower you. Join us today and become a proficient SSIS user, expanding your abilities and career opportunities in the world of data management. Take advantage of this opportunity to boost your data-handling capabilities!

By the end of this course, you will be able to:

Explain the purpose and real-world applications of SQL Server Integration Services (SSIS).
Navigate the SSIS interface, including using the SSIS Toolbox and Solutions Explorer.
Create control flow structures in SSIS packages to manage tasks efficiently.
Manage data transformation using different components in the Data Flow section.
Construct SSIS expressions, including string functions, to manipulate data.
Utilize mathematical functions and data conversion transformations for ETL processes.
Implement various SSIS transformations to aggregate, merge, and modify data.
Combine data from multiple sources using Union All, Merge, and Merge Join transformations.
Perform data lookups and understand the options for SSIS Lookup cache modes.
Set up and use parameters at both project and package levels, and handle errors efficiently in your SSIS packages.

This course includes:

2.5 hours of video tutorials
19 individual video lectures
Course and Exercise files to follow along
Certificate of completion

Who this course is for:

Those who are new to SQL Server and want to use Microsoft's SSIS
Data analysts

Introduction to SQL Server Integration Services (SSIS)

What you'll learn

Explore related topics

Course content

First Look at SSIS8 lectures • 42min

Expressions & Transformation5 lectures • 56min

Level up Your Data Integration5 lectures • 47min

Exercise and Conclusion4 lectures • 15min

Additional Training2 lectures • 55min

Requirements

Description

Who this course is for: