Video description
Welcome to the video portion of Knight's
24-Hour Trainer: Microsoft® SQL Server® 2008 Integration
Services
A unique book-and-video package for
learning Microsoft SQL Server Integration Services
If you need a practical, hands-on introduction to Microsoft
SQL Server 2008 Integration Services (SSIS), this book and video
package from foremost SSIS authority Brian Knight gets you
thoroughly up to speed. Each lesson in the book includes three
major components: a thorough description of how each SSIS feature
or process works; a tutorial that walks you through the process or
technique; and a video lesson that demonstrates it.
Every lesson in the book is supplemented by instructional
video on the DVD
Table of Contents
Introduction to SQL Server® Integration Services
00:03:13
Lesson 1: Moving Data with the Import and Export Wizard
00:04:12
Lesson 2: Installing SQL Server Integration Services
00:04:45
Lesson 3: Installing the Sample Databases
00:04:05
Lesson 4: Creating a Solution and Project
00:04:20
Lesson 5: Exploring Business Intelligence Development Studio
00:06:23
Lesson 6: Creating your First Package
00:07:29
Lesson 7: Connecting Control Flow Tasks with Precedence Constraints
00:04:49
Lesson 8: Manipulating Files with the File System Task
00:08:36
Lesson 9: Coding Custom Script Tasks
00:12:22
Lesson 10: Using the Execute SQL Task
00:11:50
Lesson 11: Using the Send Mail Task
00:08:44
Lesson 12: Using the FTP Task
00:06:08
Lesson 13: Creating a Data Flow
00:06:46
Lesson 14: Extracting Data from Sources
00:20:45
Lesson 15: Loading Data to a Destination
00:20:04
Lesson 16: Changing Data Types with the Data Conversion Transform
00:14:41
Lesson 17: Creating and Replacing Columns with the Derived Column Transform
00:13:01
Lesson 18: Rolling Up Data with the Aggregate Transform
00:06:15
Lesson 19: Ordering Data with the Sort Transform
00:09:53
Lesson 20a: Joining Data with the Lookup Transform (without the Cache Connection Manager)
00:11:36
Lesson 20b: Joining Data with the Lookup Transform (with the Cache Connection Manager)
00:07:01
Lesson 21: Auditing Data with the Row Count Transform
00:09:44
Lesson 22: Combining Multiple Inputs with the Union All Transform
00:11:52
Lesson 23: Cleansing Data with the Script Component
00:12:41
Lesson 24: Separating Data with the Conditional Split Transform
00:17:17
Lesson 25: Altering Rows with the OLE DB Command Transform
00:19:43
Lesson 26: Handling Bad Data with the Fuzzy Lookup Transform
00:20:48
Lesson 27: Removing Duplicates with the Fuzzy Group Transform
00:16:03
Lesson 28: Making a Package Dynamic with Variables
00:11:09
Lesson 29: Making a Connection Dynamic with Expressions
00:13:16
Lesson 30: Making a Task Dynamic with Expressions
00:07:50
Lesson 31: Using Sequence Containers to Organize a Package
00:07:10
Lesson 32: Using for Loop Containers to Repeat Control Flow Tasks
00:12:08
Lesson 33: Using the Foreach Loop Container to Loop through a Collection of Objects
00:15:30
Lesson 34: Easing Deployment with Configuration Tables
00:12:06
Lesson 35: Easing Deployment with Configuration Files
00:13:30
Lesson 36: Configuring Child Packages
00:11:05
Lesson 37: Logging Package Data
00:06:28
Lesson 38: Using Event Handlers
00:09:56
Lesson 39: Troubleshooting Errors
00:06:13
Lesson 40: Using Data Viewers
00:07:39
Lesson 41: Using Breakpoints
00:08:19
Lesson 42: Deploying Packages
00:07:22
Lesson 43: Configuring the SSIS Service
00:05:33
Lesson 44: Securing SSIS Packages
00:03:29
Lesson 45: Running SSIS Packages
00:04:57
Lesson 46: Scheduling Packages
00:05:24
Lesson 47: Loading a Dimension Table
00:11:42
Lesson 48: Loading a Fact Table
00:10:24
Lesson 49 Bringing It All Together
00:16:19