Books & Videos

Table of Contents

Chapter: Introduction

Introduction to SQL Server Integration Services (SSIS) LiveLessons

04m 12s

Chapter: Lesson 1: SSIS Overview

Learning objectives

00m 25s

1.1 SQL Server Data Tools

05m 29s

1.2 Connection Manager

06m 15s

1.3 Control Flow

05m 51s

1.4 Data Flow

08m 0s

Chapter: Lesson 2: Control Flow Basics

Learning objectives

00m 35s

2.1 Execute Process Task

03m 22s

2.2 Expression Task

04m 27s

2.3 File System Task

08m 57s

2.4 FTP Task

06m 3s

2.5 Script Task

06m 3s

2.6 Send Mail Task

06m 42s

2.7 For Loop Container

08m 3s

2.8 Foreach Loop Container

08m 37s

2.9 Sequence Container

03m 0s

2.10 Precedence Constraints

12m 5s

Chapter: Lesson 3: Data Flow - Sources and Destinations

Learning objectives

00m 33s

3.1 Source Overview

02m 58s

3.2 OLE DB and ADO NET Sources

07m 25s

3.3 ODBC Source

07m 22s

3.4 Flat File Source

15m 20s

3.5 Excel Source

06m 11s

3.6 Source Assistant

03m 51s

3.7 Destination Overview

03m 10s

3.8 SQL Server and OLE DB Destination

08m 14s

3.9 ODBC Destination

02m 30s

3.10 Flat File Destination

06m 35s

3.11 Excel Destination

04m 54s

3.12 Destination Assistant

02m 1s

Chapter: Lesson 4: Data Flow Transformations

Learning objectives

00m 30s

4.1 Transformations Overview

03m 33s

4.2 Copy Column

04m 37s

4.3 Data Conversion

06m 52s

4.4 Derived Column

09m 22s

4.5 Sort

08m 24s

4.6 Aggregate

06m 57s

4.7 Multicast

06m 58s

4.8 Merge

08m 51s

4.9 Merge Join

06m 2s

4.10 Union All

04m 54s

4.11 Conditional Split

11m 15s

4.12 Lookup

11m 48s

4.13 Audit

03m 47s

Chapter: Lesson 5: Using Scripts and Variables in SSIS

Learning objectives

00m 37s

5.1 How Scripts Integrate into SSIS

01m 22s

5.2 Control Flow Scripts

07m 13s

5.3 Data Flow Scripts

10m 21s

5.4 Variables

08m 27s

5.5 Variables in Script

08m 3s

Chapter: Lesson 6: Expressions

Learning objectives

00m 38s

6.1 Expressions Defined

02m 17s

6.2 Identifiers

03m 41s

6.3 Literals

04m 58s

6.4 Functions

06m 52s

6.5 Operators

06m 56s

6.6 Components that use Expressions

10m 44s

Chapter: Lesson 7: Performing Database Maintenance

Learning objectives

00m 43s

7.1 Maintenance Plans versus SSIS

04m 12s

7.2 Backup Databases

04m 6s

7.3 Check Integrity

01m 42s

7.4 Run SQL Server Jobs

03m 4s

7.5 Notify Operator

03m 48s

7.6 Working with Indexes

03m 48s

Chapter: Lesson 8: Debugging and Troubleshooting

Learning objectives

00m 30s

8.1 Metadata

06m 17s

8.2 Data Viewers

06m 21s

8.3 Package Logging

07m 16s

Chapter: Lesson 9: Deploying and Storing Packages

Learning objectives

00m 36s

9.1 Storing and Deploying Packages

05m 8s

9.2 Scheduling SSIS Packages

04m 2s

Chapter: Lesson 10: SSIS LiveLesson Review

Learning objectives

00m 49s

10.1 "Bringing it all Together" Demo

33m 13s

Chapter: Summary

Summary of SQL Server Integration Services (SSIS) LiveLessons

02m 24s