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

by Knight, Brian; Knight, Devin; Davis, Mike

• ISBN13: 9780470496923
• ISBN10: 0470496924
• Edition: DVD
• Format: Paperback
• Copyright: 2009-07-20
• Publisher: Wrox

Summary

yA unique book-and-video package for learning Microsoft SQL Server Integration ServicesIf 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.If you take full advantage of this comprehensive package, you will gain enough experience to tackle your first SSIS project with confidence. SQL Server Integration Services 2008 (SSIS) builds on the revolutionary database product suite first introduced by Microsoft in 2005 and is a powerful tool for performing extraction, transformation, and load (ETL) operations essential to data warehousing If you're just learning SSIS, the step-by-step tutorials in this book and DVD training package will ready you to tackle your own first project Every lesson in the book is supplemented by instructional video on the DVDNote: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Author Biography

Brian Knight, SQL Server MVP, MCITP, MCSE, MCDBA, is the owner and founder of Pragmatic Works. He is also the co-founder of SQLServerCentral.com and JumpstartTV.com. He runs the local SQL Server users group in Jacksonville (JSSUG). Brian is a contributing columnist at several technical magazines and does regular webcasts at Jumpstart TV. He is the author of ten SQL Server books. Brian has spoken at conferences like PASS, SQL Connections, and TechEd and many Code Camps. His blog can be found at http://www.pragmaticworks.com. Brian watches his 401k wither away in Jacksonville, Florida.

Devin Knight is a BI consultant at Pragmatic Works. Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services (John Wiley & Sons, Inc.). Devin has spoken at past conferences like PASS and at several SQL Saturday events. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader in the SSIS Focus Group. Making his home in Jacksonville, Florida, Devin is a participating member of the local users’ group (JSSUG). Visit his blog at http://pragmaticworks.com/community/blogs/.

Mike Davis (Jacksonville, Florida) is an author, developer, consultant, and trainer with Pragmatic Works. He has expertise in many areas of Business Intelligence including Integration Services, Reporting Services, Analysis Services, Database Administration, and .NET Software Development. Mike has created enterprise level BI and software solutions for numerous corporations. As a trainer he travels the world teaching classes on SQL Server and BI. He also participates as a speaker at events like SQL Saturdays, SQL Server launches, SQL server user groups, and SQL PASS. In his spare time Mike plays guitar and darts. He is a member of the North Florida Dart League.

Table of Contents

Preface

Welcome To SSIS

Installation and Getting Started

Moving Data with the Import and Export Wizard

Installing SQL Server Integration Services

Installing the Sample Databases

Creating a Solution and Project

Exploring Business Intelligence Development Studio

Creating Your First Package

Tasks

Connecting Control Flow Tasks with Precedence Constraints

Manipulating Files with the File System Task

Coding Custom Script Tasks

Using the Execute SQL Task

Using the Send Mail Task

Using the FTP Task

Creating a Data Flow

Data Flow

Extracting Data from Sources

Loading Data to a Destination

Changing Data Types with the Data Conversion Transform

Creating and Replacing Columns with the Derived Column Transform

Rolling Up Data with the Aggregate Transform

Ordering Data with the Sort Transform

Joining Data with the Lookup Transform

Auditing Data with theRow Count Transform

Combining Multiple Inputs with the Union All Transform

Cleansing Data with the Script Component

Separating Data with the Conditional Split Transform

Altering Rows with the OLE DB Command Transform

Handling Bad Data with the Fuzzy Lookup Transform

Removing Duplicates with the Fuzzy Grouping Transform

Variables and Expressions

Making a Package Dynamic with Variables

Making a Connection Dynamic with Expressions

Making a Task Dynamic with Expressions

Containers

Using Sequence Containers to Organize a Package

Using For Loop Containers to Repeat Control Flow Tasks

Using the Foreach Loop Container to Loop Through a Collection of Objects

Configuration

Easing Deployment with Configuration Tables

Easing Deployment with Configuration Files

Configuring Child Packages

Troubleshooting and Logging

Logging Package Data

Using Event Handlers

Troubleshooting Errors

Using Data Viewers

Using Breakpoints

Deployment and Administration

Deploying Packages

Configuring the SSIS Service

Securing SSIS Packages

Running SSIS Packages

Scheduling Packages

Data Warehousing

Loading a Dimension Table

Loading a Fact Table

Wrap Up and Review

Bringing It All Together

SSIS Component Crib Notes

Problem and Solution Crib Notes

What's on the DVD?

Index

Table of Contents provided by Publisher. All Rights Reserved.