Knight's 24-Hour Trainer: Microsoft® SQL Server® 2008 Integration Services

Knight's 24-Hour Trainer: Microsoft® SQL Server® 2008 Integration Services

Released July 2009
Publisher(s): Wrox
ISBN: 978047049692

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

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

  1. Introduction to SQL Server® Integration Services 00:03:13
  2. Lesson 1: Moving Data with the Import and Export Wizard 00:04:12
  3. Lesson 2: Installing SQL Server Integration Services 00:04:45
  4. Lesson 3: Installing the Sample Databases 00:04:05
  5. Lesson 4: Creating a Solution and Project 00:04:20
  6. Lesson 5: Exploring Business Intelligence Development Studio 00:06:23
  7. Lesson 6: Creating your First Package 00:07:29
  8. Lesson 7: Connecting Control Flow Tasks with Precedence Constraints 00:04:49
  9. Lesson 8: Manipulating Files with the File System Task 00:08:36
  10. Lesson 9: Coding Custom Script Tasks 00:12:22
  11. Lesson 10: Using the Execute SQL Task 00:11:50
  12. Lesson 11: Using the Send Mail Task 00:08:44
  13. Lesson 12: Using the FTP Task 00:06:08
  14. Lesson 13: Creating a Data Flow 00:06:46
  15. Lesson 14: Extracting Data from Sources 00:20:45
  16. Lesson 15: Loading Data to a Destination 00:20:04
  17. Lesson 16: Changing Data Types with the Data Conversion Transform 00:14:41
  18. Lesson 17: Creating and Replacing Columns with the Derived Column Transform 00:13:01
  19. Lesson 18: Rolling Up Data with the Aggregate Transform 00:06:15
  20. Lesson 19: Ordering Data with the Sort Transform 00:09:53
  21. Lesson 20a: Joining Data with the Lookup Transform (without the Cache Connection Manager) 00:11:36
  22. Lesson 20b: Joining Data with the Lookup Transform (with the Cache Connection Manager) 00:07:01
  23. Lesson 21: Auditing Data with the Row Count Transform 00:09:44
  24. Lesson 22: Combining Multiple Inputs with the Union All Transform 00:11:52
  25. Lesson 23: Cleansing Data with the Script Component 00:12:41
  26. Lesson 24: Separating Data with the Conditional Split Transform 00:17:17
  27. Lesson 25: Altering Rows with the OLE DB Command Transform 00:19:43
  28. Lesson 26: Handling Bad Data with the Fuzzy Lookup Transform 00:20:48
  29. Lesson 27: Removing Duplicates with the Fuzzy Group Transform 00:16:03
  30. Lesson 28: Making a Package Dynamic with Variables 00:11:09
  31. Lesson 29: Making a Connection Dynamic with Expressions 00:13:16
  32. Lesson 30: Making a Task Dynamic with Expressions 00:07:50
  33. Lesson 31: Using Sequence Containers to Organize a Package 00:07:10
  34. Lesson 32: Using for Loop Containers to Repeat Control Flow Tasks 00:12:08
  35. Lesson 33: Using the Foreach Loop Container to Loop through a Collection of Objects 00:15:30
  36. Lesson 34: Easing Deployment with Configuration Tables 00:12:06
  37. Lesson 35: Easing Deployment with Configuration Files 00:13:30
  38. Lesson 36: Configuring Child Packages 00:11:05
  39. Lesson 37: Logging Package Data 00:06:28
  40. Lesson 38: Using Event Handlers 00:09:56
  41. Lesson 39: Troubleshooting Errors 00:06:13
  42. Lesson 40: Using Data Viewers 00:07:39
  43. Lesson 41: Using Breakpoints 00:08:19
  44. Lesson 42: Deploying Packages 00:07:22
  45. Lesson 43: Configuring the SSIS Service 00:05:33
  46. Lesson 44: Securing SSIS Packages 00:03:29
  47. Lesson 45: Running SSIS Packages 00:04:57
  48. Lesson 46: Scheduling Packages 00:05:24
  49. Lesson 47: Loading a Dimension Table 00:11:42
  50. Lesson 48: Loading a Fact Table 00:10:24
  51. Lesson 49 Bringing It All Together 00:16:19

Product information

  • Title: Knight's 24-Hour Trainer: Microsoft® SQL Server® 2008 Integration Services
  • Author(s):
  • Release date: July 2009
  • Publisher(s): Wrox
  • ISBN: 978047049692