Knight's Microsoft SQL Server 2012 Integration Services 24-Hour Trainer

Table of Contents

Cover

Welcome to SISS

Section 1

Chapter 1: Moving Data with the Import and Export Wizard

Try It

Chapter 2: Installing SQL Server Integration Services

Chapter 3: Installing the Sample Databases

Try It

Chapter 4: Creating a Solution and Project

Try It

Chapter 5: Exploring SQL Server Data Tools

The Solution Explorer

Deployment Models

The Properties Window

The Toolbox

The SSDT Design Environment

Chapter 6: Creating Your First Package

Creating and Using Connection Managers

Using and Configuring Tasks

Exploring Package Encryption

Executing Packages

Try It

Chapter 7: Upgrading Packages to SQL Server 2012

Try It

Chapter 8: Upgrading to the Project Deployment Model

Try It

Section 2

Chapter 9: Using Precedence Constraints

Try It

Chapter 10: Manipulating Files with the File System Task

Try It

Chapter 11: Coding Custom Script Tasks

Try It

Chapter 12: Using the Execute SQL Task

Try It

Chapter 13: Using the Execute Process Task

Try It

Chapter 14: Using the Expression Task

Try It

Chapter 15: Using the Send Mail Task

Try It

Chapter 16: Using the FTP Task

Try It

Chapter 17: Creating a Data Flow

Try It

Section 3

Chapter 18: Extracting Data from Sources

Source Assistant

OLE DB Source

Excel Source

Flat File Source

Chapter 19: Loading Data to a Destination

Destination Assistant

OLE DB Destination

Flat File Destination

Excel Destination

Chapter 20: Changing Data Types with the Data Conversion Transform

Try It

Chapter 21: Creating and Replacing Columns with the Derived Column Transform ...