Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

Introduction to SQL Server 2016 Integration Services (SSIS)

Video Introducing this tutorial

Introduction
SQL Server 2016 Integration Services: Introduction 00:03:52


Lesson 1: SSIS Overview
Learning objectives 00:00:34
1.1 Understand SQL Server data tools 00:06:16
1.2 Use connection manager 00:05:24
1.3 Understand SSIS control flows 00:04:42
1.4 Understand SSIS data flows 00:07:48


Lesson 2: Control Flow Basics
Learning objectives 00:00:52
2.1 Configure the execute process task 00:10:18
2.2 Use the expression task 00:08:21
2.3 Create file system tasks 00:14:13
2.4 Configure the FTP task 00:11:28
2.5 Code with the script task 00:08:33
2.6 Send e-mail with the send mail task 00:08:36
2.7 Implement for loop containers 00:07:37
2.8 Use the foreach loop container 00:13:04
2.9 Configure sequence containers 00:04:43
2.10 Use precedence constraints 00:10:20


Lesson 3: Data Flow—Sources and Destinations
Learning objectives 00:00:58
3.1 Understand data flow sources 00:03:29
3.2 Connect to the OLE DB and ADO .NET sources 00:10:52
3.3 Use the ODBC source 00:06:44
3.4 Configure a flat file source 00:13:20
3.5 Work with the Excel source 00:07:41
3.6 Use the source assistant 00:03:50
3.7 Understand data flow destinations 00:03:13
3.8 Configure SQL Server and OLE DB destinations 00:08:25
3.9 Understand the ODBC destination 00:03:49
3.10 Use the flat file destination 00:07:33
3.11 Configure the Excel destination 00:05:39
3.12 Work with the destination assistant 00:02:25


Lesson 4: Data Flow—Transformations
Learning objectives 00:01:11
4.1 Use data flow transformations 00:02:23
4.2 Configure the copy column transformation 00:07:50
4.3 Configure the data conversion transformation 00:07:53
4.4 Use derived columns 00:12:41
4.5 Implement the sort transformation 00:09:32
4.6 Configure the aggregate transformation 00:09:36
4.7 Use multicast 00:06:56
4.8 Understand the merge transformation 00:11:02
4.9 Use the merge join transformation 00:15:25
4.10 Configure a union all transformation 00:09:40
4.11 Set up conditional split transformations 00:11:42
4.12 Use the lookup transformation with an OLE DB connection manager 00:16:28
4.13 Use the lookup transformation with a cache connection manager 00:09:27
4.14 Understand the audit transformation 00:03:14


Lesson 5: Using Scripts and Variables in SSIS
Learning objectives 00:00:44
5.1 Integrate scripts into SSIS 00:01:39
5.2 Set up control flow scripts 00:04:35
5.3 Configure data flow scripts 00:16:12
5.4 Add variables to packages 00:11:36
5.5 Use variables in scripts 00:06:10


Lesson 6: Expressions
Learning objectives 00:00:45
6.1 Work with custom expressions 00:03:06
6.2 Understand identifiers in expressions 00:02:01
6.3 Understand literals in expressions 00:07:49
6.4 Create custom expressions 00:12:28
6.5 Understand mathematic operators 00:10:56
6.6 Work with components that use expressions 00:10:18


Lesson 7: Performing Database Maintenance
Learning objectives 00:00:48
7.1 Compare SQL Server maintenance plans to SSIS task 00:03:21
7.2 Perform databases backups 00:07:57
7.3 Check database integrity 00:03:26
7.4 Run SQL Server jobs with SSIS 00:02:21
7.5 Notify SQL Server operator 00:02:39
7.6 Work with indexes 00:05:11


Lesson 8: Debugging and Troubleshooting
Learning objectives 00:00:36
8.1 Understand SSIS metadata 00:05:33
8.2 Examine data with SSIS data viewers 00:04:20
8.3 Implement SSIS package logging 00:08:16


Lesson 9: Deploying and Storing Packages
Learning objectives 00:00:33
9.1 Store and deploy packages 00:10:43
9.2 Schedule SSIS packages 00:05:42


Summary
SQL Server 2016 Integration Services: Summary 00:02:00