Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services (Wrox Programmer to Programmer) (Paperback)

~ Brian Knight (Author), Devin Knight (Author), Mike Davis (Author)

Editorial Reviews

Product Description

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.

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: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

From the Back Cover

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.

See all Editorial Reviews

Product Details

• Paperback: 384 pages
• Publisher: Wrox; Pap/Dvdr edition (July 20, 2009)
• Language: English
• ISBN-10: 0470496924
• ISBN-13: 978-0470496923
• Product Dimensions: 9.1 x 7.3 x 1.1 inches
• Shipping Weight: 1.2 pounds (View shipping rates and policies)
• Average Customer Review: 4.9 out of 5 stars  See all reviews (9 customer reviews)
• Amazon.com Sales Rank: #36,475 in Books (See Bestsellers in Books)

  Popular in these categories: (What's this?)

  #6 in	Books > Computers & Internet > Databases > Data Warehousing
  #16 in	Books > Computers & Internet > Microsoft > Development > SQL Server
  #29 in	Books > Computers & Internet > Databases > Database Management Systems

Customer Reviews

Most Helpful Customer Reviews

5 of 5 people found the following review helpful:

5.0 out of 5 stars Productivity in a Book, July 29, 2009

By	Brian K. Seitz (Eatonville, Wa USA) - See all my reviews (REAL NAME)

Most of the Wrox collection of books I have I would rate fairly high on the star scale. Knight's 24-hour trainer is not different in that assessment. The book purports itself as a beginner to productive user of SQL Server 2009 Integration Services in 24 hours.

That's a tall order given the nature and scope of Integration Servers. I have worked with various members of the SQL Dev team from time to time and they confide, that this seems to be the one area that developers lag in their knowledge. Which is a shame, because getting the data into and out of a database is one of the most critical tasks.

I approached reading the book with an open mind as I was, like others, limited in my knowledge and use of Integration Services. The book is well laid out starting out with discussing how Integration Services is structured. Following are a series of small focused lessons and exercises to take one through the key features and utilities within SSIS. This book will not make you the ultimate guru on SSIS, however it will as advertised:

1) Give you a solid understand of how SSIS is structured and operates
2) Provides you enough training to meet the 80/20 rule head-on making you productive while your reading the text.

I would strongly recommend the book to anyone that works with SQL Server

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

4 of 4 people found the following review helpful:

5.0 out of 5 stars Excellent Introduction to SSIS, August 24, 2009

By	R. Heim (Austin, TX) - See all my reviews (REAL NAME)

Knight's book is a great introduction to SSIS having beginners up and running in no time. The lessons are straightforward and just as comprehensive as most 3 or 4 day training courses that run a grand or more.

3 of 3 people found the following review helpful:

5.0 out of 5 stars Knight's 24 Hour Trainer, August 20, 2009

By	Carol Y. Pinckney - See all my reviews (REAL NAME)

I love this book. It is a great training tool. I am new to Microsoft SQL Server so it has become my Bible. The lessons at the end of each chapter are great for beginners. Plus you get it all on a DVD. Thanks guys for such great information provided with simplicity.