Learn how to design and implement ETL solutions using Microsoft SQL Server 2016 Integration Services (SSIS). This guide provides proven methods to support common ETL needs, such as databases communicating directly, using files to exchange data, or performing database operations using Web services.
Readers will learn by example how to use SSIS as they design and implement extract, transform, and load (ETL) solutions to support a business application that integrates with a data warehouse and an online Web store across a heterogeneous system.