Who is This Book For?

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.

Code Examples

All of the examples in this book were created in Visual Studio. The code examples are formatted in blocks as follows:

Notes

Throughout this book, there are notes that highlight particularly interesting information about a language feature, including potential pitfalls you will want to avoid.

Note: Null values are ignored when evaluating any aggregate function.