A unique book-and-video package for learning Microsoft SQLServer Integration Services If you need a practical, hands-on introduction to Microsoft SQLServer 2008 Integration Services (SSIS), this book and videopackage from foremost SSIS authority Brian Knight gets youthoroughly up to speed. Each lesson in the book includes threemajor components: a thorough description of how each SSIS featureor process works; a tutorial that walks you through the process ortechnique; and a video lesson that demonstrates it. If you take full advantage of this comprehensive package, youwill gain enough experience to tackle your first SSIS project withconfidence. * SQL Server Integration Services 2008 (SSIS) builds on therevolutionary database product suite first introduced by Microsoftin 2005 and is a powerful tool for performing extraction,transformation, and load (ETL) operations essential to datawarehousing * If you're just learning SSIS, the step-by-step tutorials inthis book and DVD training package will ready you to tackle yourown first project * Every lesson in the book is supplemented by instructional videoon the DVD Note:As a part of this title, video lessons are included onDVD. For the e-book versions, video lessons can be accessed atwrox.com using a link provided in the interior of thee-book.

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.

Don't let SQL Server Integration Services (SSIS) intimidate you. Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services is a unique lesson-based book that walks you through the essential parts of SSIS without all of the fluff. Each lesson is streamlined to teach a specific component of SSIS, helping you to focus on just what you need in order to succeed in your job. If you learn better by getting your hands on the product, this book provides you with a step-by-step lab for each lesson with a video to accompany it.

The authors guide you from the ground-up and make no assumption of previous knowledge of SSIS. The 49 featured lessons help you develop a strong foundation for this highly marketable skill. Additionally, you'll get useful tools like cheat sheets on the SSIS expression language and you'll learn when to use each task.

Each lesson has three major components: a description of how to use the given SSIS feature, a tutorial, and an instructor-led video. No matter your learning style, you'll glean new information from each lesson with this unique style of training. It's like having a one-on-one instructor in your office showing you SSIS. Learning SSIS has never been so simple.

What you will learn from this book and DVD

• How to install and configure SSIS

• How to create and edit tasks in the Control Flow

• Methods for designing the core sources, transforms, and destinations of Data Flows

• How to develop Control Flows with For Loop and Foreach Loop Containers

• How to make your package dynamic with variables and expressions

• Methods for updating your package remotely with configuration files and tables

• Techniques for transferring information from parent to child packages

• Techniques for loading a data warehouse using SSIS

• Tips for troubleshooting common SSIS challenges

Who this book is for

This book is for SQL Server database administrators and developers who are new to SSIS.

Wrox guides are crafted to make learning programming languages and technologies easier than you think. Written by programmers for programmers, they provide a structured, tutorial format that will guide you through all the techniques involved.

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.

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 DVD

Note:As a part of this title, video lessons are included on DVD. For the e-book versions, video lessons can be accessed at wrox.com using a link provided in the interior of the e-book.

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 Des…