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

Welcome To SSIS.

Section I: Installation and Getting Started

Lesson 1: Moving Data with the Import and Export Wizard.

Lesson 2: Installing SQL Server Integration Services.

Lesson 3: Installing the Sample Databases.

Lesson 4: Creating a Solution and Project.

Lesson 5: Exploring Business Intelligence Development Studio.

Lesson 6: Creating Your First Package.

Section II: Tasks.

Lesson 7: Connecting Control Flow Tasks with Precedence Constraints.

Lesson 8: Manipulating Files with the File System Task.

Lesson 9: Coding Custom Script Tasks.

Lesson 10: Using the Execute SQL Task.

Lesson 11: Using the Send Mail Task.

Lesson 12: Using the FTP Task.

Lesson 13: Creating a Data Flow.

Section III: Data Flow.

Lesson 14: Extracting Data from Sources.

Lesson 15: Loading Data to a Destination.

Lesson 16: Changing Data Types with the Data Conversion Transform.

Lesson 17: Creating and Replacing Columns with the Derived Column Transform.

Lesson 18: Rolling Up Data with the Aggregate Transform.

Lesson 19: Ordering Data with the Sort Transform.

Lesson 20: Joining Data with the Lookup Transform.

Lesson 21: Auditing Data with theRow Count Transform.

Lesson 22: Combining Multiple Inputs with the Union All Transform.

Lesson 23: Cleansing Data with the Script Component.

Lesson 24: Separating Data with the Conditional Split Transform.

Lesson 25: Altering Rows with the OLE DB Command Transform.

Lesson 26: Handling Bad Data with the Fuzzy Lookup Transform.

Lesson 27: Removing Duplicates with the Fuzzy Grouping Transform.

Section IV: Variables and Expressions.

Lesson 28: Making a Package Dynamic with Variables.

Lesson 29: Making a Connection Dynamic with Expressions.

Lesson 30: Making a Task Dynamic with Expressions.

Section V: Containers.

Lesson 31: Using Sequence Containers to Organize a Package.

Lesson 32: Using For Loop Containers to Repeat Control Flow Tasks.

Lesson 33: Using the Foreach Loop Container to Loop Through a Collection of Objects.

Section VI: Configuration.

Lesson 34: Easing Deployment with Configuration Tables.

Lesson 35: Easing Deployment with Configuration Files.

Lesson 36: Configuring Child Packages.

Section VII: Troubleshooting and Logging.

Lesson 37: Logging Package Data.

Lesson 38: Using Event Handlers.

Lesson 39: Troubleshooting Errors.

Lesson 40: Using Data Viewers.

Lesson 41: Using Breakpoints.

Section VIII: Deployment and Administration.

Lesson 42: Deploying Packages.

Lesson 43: Configuring the SSIS Service.

Lesson 44: Securing SSIS Packages.

Lesson 45: Running SSIS Packages.

Lesson 46: Scheduling Packages.

Section IX: Data Warehousing.

Lesson 47: Loading a Dimension Table.

Lesson 48: Loading a Fact Table.

Section X: Wrap Up and Review.

Lesson 49: Bringing It All Together.

Appendix A: SSIS Component Crib Notes.

Appendix B: Problem and Solution Crib Notes.

Appendix C: What’s on the DVD?

Index.