SQL Server Integration Services (SSIS) is one of the core add-on components to SQL Server. With SSIS, professionals can create automated workflows that streamline the process of consolidating data from a wide variety of sources. Through a process called ETL—extract, transform, and load—you can ingest and move data between systems such as other databases, flat data files, and even online repositories. In this course, Adam Wilbert helps you get up and running with SSIS. Adam shows how to work with different control flow tasks, data sources, connections, and transformations. Plus, see how to add variables to control package execution, run packages with T-SQL, and more.

Topics include:

Managing and administering SQL with SSIS tasks

Making packages dynamic with variables and parameters

Creating a sequence container

Extracting data from a source

Handling errors

Running packages with T-SQL

Scheduling packages with SQL Server Agent

HOMEPAGE

https://www.lynda.com/SQL-Server-tutorials/SQL-Server-Integration-Services-2019/2806967-2.html