English | March 5, 2018 | ASIN: B07B8Q5FLY | 116 Pages | PDF | 3 MB
SQL Server Integration Services is part of Microsoft's business intelligence suite and an ETL (extract, transform, and load) tool. It does more than just move data between databases. It can be used to clean and transform data so that it can be used by data warehouses or even OLAP-based systems. With SSIS Succinctly by Rui Machado, you will learn how to build and deploy your own ETL solution in a drag-and-drop development environment by using SSIS packages, control flows, data flows, tasks, and more.
This book is for all developers who want to enrich their knowledge about extract, transform, and load operations (ETL) using SQL Server Integration Services. Although the main targets are developers, every information systems professional will be able to understand how Integration Services works and how to use it to develop ETL processes. This is a book based in the visual environment (SQL Server Data Tools or SSDT) and is designed to be easy to use and understand.