Programming Books C Java PHP Python Learn more Browse Programming Books
Knight's 24-Hour Trainer and over one million other books are available for Amazon Kindle. Learn more

Sorry, this item is not available in
Image not available for
Image not available

To view this video download Flash Player


Sign in to turn on 1-Click ordering
Sell Us Your Item
For a $2.85 Gift Card
Trade in
More Buying Choices
Have one to sell? Sell yours here
Start reading Knight's 24-Hour Trainer on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

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

by Brian Knight, Devin Knight, Mike Davis
4.2 out of 5 stars  See all reviews (44 customer reviews)

List Price: $49.99
Price: $33.80 & FREE Shipping on orders over $35. Details
You Save: $16.19 (32%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 17 left in stock (more on the way).
Ships from and sold by Gift-wrap available.
Want it tomorrow, April 25? Choose One-Day Shipping at checkout. Details
Free Two-Day Shipping for College Students with Amazon Student


Amazon Price New from Used from
Kindle Edition $28.49  
Paperback $33.80  
Sell Us Your Books
Get up to 80% back when you sell us your books, even if you didn't buy them at Amazon. Learn more

Book Description

July 20, 2009 0470496924 978-0470496923 1
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:As a part of this title, video lessons are included on DVD. For the e-book versions, video lessons can be accessed at using a link provided in the interior of the e-book.

Frequently Bought Together

Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services + Professional Microsoft SQL Server 2008 Integration Services + Microsoft SQL Server 2008 Integration Services: Problem, Design, Solution
Price for all three: $99.22

Buy the selected items together

Editorial Reviews

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.

About the Author

Brian Knight, SQL Server MVP, MCITP, MCSE, MCDBA, is the owner and founder of Pragmatic Works. He is also the co-founder of and 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 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

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.

Product Details

  • Paperback: 384 pages
  • Publisher: Wrox; 1 edition (July 20, 2009)
  • Language: English
  • ISBN-10: 0470496924
  • ISBN-13: 978-0470496923
  • Product Dimensions: 9.1 x 7.3 x 1 inches
  • Shipping Weight: 1.2 pounds (View shipping rates and policies)
  • Average Customer Review: 4.2 out of 5 stars  See all reviews (44 customer reviews)
  • Amazon Best Sellers Rank: #351,533 in Books (See Top 100 in Books)

More About the Authors

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews
29 of 30 people found the following review helpful
5.0 out of 5 stars Productivity in a Book July 29, 2009
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)
Was this review helpful to you?
19 of 19 people found the following review helpful
4.0 out of 5 stars Strengths outweigh flaws January 14, 2010
I picked up this book when I needed a crash course in SSIS for a work project. While it does have some significant flaws, the book has many strong points, and in the balance I believe the strengths outweigh the weaknesses. I can't recall ever having read a book that is simultaneously so good overall yet so plagued with annoyances.

Strengths first:
* The book does a great job in the arrangement of its subjects. You can start knowing nothing about the subject, and in very little time you come out with a solid base of understanding. Also, the pacing is terrific: the stuff you'll do the most hands-on, day-to-day work with come first, with the lesser-used stuff coming later. Skimming is easy and worry-free: the book doesn't hide important bits of info within a morass of excess words, or in the middle of a handful of topics of little or no use/interest to the reader. Wrox's propensity for wordiness is thankfully absent here.
* The book can be completed in 24 hours of work. A far cry from the "Learn X in 24 Hours" books that were once so popular!
* Each lesson is just long enough, and the hands-on lessons are pertinent, focused, and otherwise implemented extremely well.
* The video lessons are reasonably helpful, once you get past their weankesses.

Now, the weaknesses:
* The book has many errata, few of which are noted on the book's website. And as of this writing, you can't submit errata on Wrox's website unless you are registered with Wrox... and the website's registration page is broken. And you can't submit a problem report about the registration page because you need to be registered in order to submit the problem report.
Read more ›
Was this review helpful to you?
9 of 9 people found the following review helpful
5.0 out of 5 stars Great Introduction. The videos add a lot! September 29, 2009
Format:Paperback|Verified Purchase
I hadn't heard of SSIS until the week before I bought this book. This book gave me a broad overview with enough depth to get started. Now I'm using the software for actual work. Very worthwhile.

Couple of notes:
1) Not for SQL Server Express
2) Are you old-school? SSIS is the new Data Transformation Services
3) The book is for MS SQL 2008. I'm using 2005, and could follow along easily. Minor differences.

On another note, all computer books should have video. I can't tell you how helpful that was. They didn't spend a lot of time or money making the video. They just had something running that recorded their screen actions and voice, and let them zoom in. Then they basically just showed on screen what they were talking about in the book. It looks like they spent five or ten minutes per chapter. They make it look so easy, that from now on I'm going to consider anyone who doesn't include a video in a computer book to be lazy. In other words, they raised the bar. Authors, this is the new standard. It doesn't have to be expensive to be effective. Not perfect, just useful.
Comment | 
Was this review helpful to you?
5 of 5 people found the following review helpful
5.0 out of 5 stars Excellent Introduction to SSIS August 24, 2009
By R. Heim
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.
Comment | 
Was this review helpful to you?
4 of 4 people found the following review helpful
5.0 out of 5 stars Knight's 24 Hour Trainer August 20, 2009
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.
Comment | 
Was this review helpful to you?
3 of 3 people found the following review helpful
5.0 out of 5 stars An interesting concept for a programming book February 20, 2010
This book is intended for Microsoft SQL Server database administrators who are not yet familiar with SQL Server Integration Services (SSIS). You should have enough understanding to be able to run queries manipulating data. This is a beginner level book so far as SSIS is concerned. As such it doesn't cover every little detail but by the end of the book you will have enough information to use SSIS and to get out of the SSIS documentation what you need to know.

The book has a style that I've not seen before. As a book it is rather typical in format beginning with installation and getting started then going on with a series of chapters describing how to use particular features of the software.

After that, however, it gets more interesting. The book includes a DVD that has a presentation that goes with each chapter. The idea is that you read the book then listen to the presentation. That way you get a concise review of what you should have picked up in the chapter. The reviews are given by the three authors of the book, so the presenter clearly understands the points he is discussion.

I suppose though that you could watch the presentation first and then read the chapter for the details.

There is also a web site associated with the book that provides things like the code that you can download rather than having to type in everything in the lesson.
Comment | 
Was this review helpful to you?
Most Recent Customer Reviews
1.0 out of 5 stars Surprisingly poor book
I worked a bit with DTS back in the old days, and though I spend just about all my time in T-SQL I figured I should update my skills. Read more
Published 23 hours ago by Chris McKeever
5.0 out of 5 stars Well Organized, Very Helpful SSIS Reference
This is definitely the place to start for those who wish to get up and running with SSIS quickly. They cover the critical components in small, easily digestible bites in a logical... Read more
Published 2 months ago by J. Richard Hoye
3.0 out of 5 stars Knight's 24-Hour Trainer SSIS 2008
Many steps in this book are skipped and things which you are instructed to do, are not present in the way presented by the authors. Read more
Published 2 months ago by Cecil T. Champenois Jr.
1.0 out of 5 stars Good only for Simplistic Class Projects not PRACTICAL OTHERWISE!
Good only if you are in school and need something to get you through the assignment quickly. The videos are NOT practical especially for the price they want. Read more
Published 4 months ago by John Smith
4.0 out of 5 stars Learned enough at a good level of detail
I have been in the process of learning SSIS at work and needed a little more help with it. Since I'm more visual or I like it when someone explains something to me like a 5 year... Read more
Published 8 months ago by Ian Gall
2.0 out of 5 stars Videos Not Available Offline in the Kindle Edition
I don't recommend the Kindle Edition if you are interested in the video portion of the book because they can only be viewed online with an internet connection; the videos can't be... Read more
Published 9 months ago by Andrew
4.0 out of 5 stars Good To Get Your Started
I've been using Informatica for about 10 years, and I needed to learn SSIS fast. This book has done a great job of helping me with that. The format is perfect for learning. Read more
Published 12 months ago by E. Walker
2.0 out of 5 stars Simplicity is no benefit in the long run
Face it. You're about to enter a challenging world. You hope that a step-by-step introduction will help, and it will -- if you can get by without understanding what you're doing. Read more
Published 14 months ago by 504more
5.0 out of 5 stars Fast and complete way to hone your SSIS skills
Hats off the authors of this book for making learning a new skill both enjoyable and complete. When you finish it, you'll be able to take on just about any SSIS project with... Read more
Published 17 months ago by Big Hat
5.0 out of 5 stars Highly Effective Learning Tool
As a 30 year IT veteran, I have read many instructional books. This book is one of the best. It gives you everything you need to learn. Read more
Published 23 months ago by A2Davidr
Search Customer Reviews
Only search this product's reviews


There are no discussions about this product yet.
Be the first to discuss this product with the community.
Start a new discussion
First post:
Prompts for sign-in

Look for Similar Items by Category