Don't let SQL Server Integration Services (SSIS) intimidate you.Knight's 24-Hour Trainer: Microsoft SQL Server 2008 IntegrationServices is a unique lesson-based book that walks you through theessential parts of SSIS without all of the fluff. Each lesson isstreamlined to teach a specific component of SSIS, helping you tofocus on just what you need in order to succeed in your job. If youlearn better by getting your hands on the product, this bookprovides you with a step-by-step lab for each lesson with a videoto accompany it.
The authors guide you from the ground-up and make no assumptionof previous knowledge of SSIS. The 49 featured lessons help youdevelop a strong foundation for this highly marketable skill.Additionally, you'll get useful tools like cheat sheets on the SSISexpression language and you'll learn when to use each task.
Each lesson has three major components: a description of how touse the given SSIS feature, a tutorial, and an instructor-ledvideo. No matter your learning style, you'll glean new informationfrom each lesson with this unique style of training. It's likehaving 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, anddestinations of Data Flows
How to develop Control Flows with For Loop and Foreach LoopContainers
How to make your package dynamic with variables andexpressions
Methods for updating your package remotely with configurationfiles and tables
Techniques for transferring information from parent to childpackages
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 anddevelopers who are new to SSIS.
Wrox guides are crafted to make learning programming languagesand technologies easier than you think. Written by programmers forprogrammers, they provide a structured, tutorial format that willguide you through all the techniques involved.