Ebook: SSIS Succinctly

Morrisville, Syncfusion Inc, 2014. — 116 p.
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.Contents:
The Story behind the Succinctly Series of Books
About the Author
Who is This Book For?
Introduction
Integration Services Architecture
Introduction
Explaining the Components
Runtime Engine
Integration Services Service
SSIS Designer
Log Provider
Connection Manager
SSIS Wizard
Packages
Tasks
Event Handlers
Containers
Control Flow
Data Flow Engine
Project and Package Deployment Models
Developer Environment
Introduction
SSIS Designer
Packages
4Introduction
Hello World Package—Import and Export Wizard
Custom Packages
Introduction
Adding a New Package to a Project
Executing the Packages
Package Explorer
Package Properties
Checkpoints
Execution
Forced Execution Value
Identification
Misc
Transactions
Version