Learn data integration development with SSIS (SQL Server Integration Services) tutorials.

Microsoft’s data integration tool is a complete ETL and has been a market leader for years. These SSIS tutorials on Microsoft’s ETL tool help you learn the basics of creating and using packages. It is a module of the SQL Server suite that allows many ETL operations on data such as: loading flat files, Excel files, XML files. It also allows you to load data from one database to another, via DTSX packages.

Learn SSIS development with free tutorials

Firstly, the development of SSIS packages is done with Visual Studio, the latest official version is 2022. You need to install the SQL Server Data Tools to develop Integration Services projects. However, in practice SSIS packages are XML files with a dtsx extension. These SSIS tutorials in French are online courses with a very practical approach, to learn Microsoft BI technology step by step and by example.

Indeed, the IT and SQL training site Expert-Only.com provides this 100% online and free training on SSIS. For students or beginners in business intelligence. But also for experienced IT engineers and consultants wishing to extend their BI skills with Microsoft BI tools. SSIS is an important block as the ETL part of the MS BI suite with SSAS, SSRS and Power BI.

What is the SSIS ETL?

SSIS is a data loading tool that can be used to migrate data from one location to another. SSIS is a very powerful and flexible tool that can be used for many different purposes.

The main purpose of SSIS is to load data into a database, or to transfer it from one data source to another. Here we use the SQL Server database as the target. It can also extract, transform and load data from other sources such as flat files, CSV files, Excel files, etc.

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 the process of moving data from one system to another.

Learn SSIS with practical examples

The tutorials are based on an older version of SQL Server and are gradually updated to the latest versions of MS SQL. The current version is Microsoft SQL Server 2019.

1. Set up the SSIS development environment

First and foremost, to learn about data integration and develop your first project, start by installing the Microsoft SQL Server BI development environment. Here are the necessary software packages:

2. Tutorials to create SSIS solutions, projects, and basic packages

Then create simple control flows and data flows to learn how to manipulate data and files with SSIS.

3. Develop packages to import files into a SQL database

Secondly, these tutorials on Microsoft SSIS ETL in French are about file management. And especially the import of data from an external source to a database. In these examples, the target database is a SQL Server database.

4. Tutorials to manage SSIS packages

  1. How to deploy SSIS packages with cmd and the dtutil tool?