- Paperback: 384 pages
- Publisher: Wrox; 1 edition (July 20, 2009)
- Language: English
- ISBN-10: 0470496924
- ISBN-13: 978-0470496923
- Product Dimensions: 7.4 x 0.9 x 9 inches
- Shipping Weight: 1.2 pounds (View shipping rates and policies)
- Average Customer Review: 48 customer reviews
- Amazon Best Sellers Rank: #994,703 in Books (See Top 100 in Books)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
Fulfillment by Amazon (FBA) is a service we offer sellers that lets them store their products in Amazon's fulfillment centers, and we directly pack, ship, and provide customer service for these products. Something we hope you'll especially enjoy: FBA items qualify for FREE Shipping and Amazon Prime.
If you're a seller, Fulfillment by Amazon can help you increase your sales. We invite you to learn more about Fulfillment by Amazon .
Frequently bought together
Customers who bought this item also bought
Customers who viewed this item also viewed
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 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.
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
However, I'm pretty sure you'll need to have a decent amount of familiarity with databases, and possibly some familiarity with ETL tools to get going. Setting up the sample database is difficult for someone who hasn't had some experience with SQL Server. (This was my one gripe-- I couldn't figure out how to get the database into SQL Server, because I know Oracle not SQL Server.) But overall, you probably shouldn't be bothering to learn an ETL tool if you don't have a solid understanding of databases.... Also you can get by with just about any database... it doesn't have to be the one that matches to book. (I got help from a coworker loading the DB.)
So what this book isn't.....
It isn't an "expert's guide." This is a "getting started" guide. This gives you BASIC skills, that you can flesh out either by doing, or with more study. Some concepts are glossed over, and that's to be expected. Chapters build on each other, so you pretty much need to start at the beginning to get to the end.
The production quality of the videos isn't super high; The speaker stumbles every now and then, and it is hard to read all the text on the screen. The point of the videos is to help you do the exercises yourself, so you should have your own screen to look at for small text. The videos aren't intended for you to sit and watch like a Disney movie... they're there to supplement your learning... and get you through things you might not understand from the book alone.
This is not a book on datawarehousing or general ETL concepts. This book gives you an introduction to one specific ETL tool, and that's it. You will be shown how to load data to a table, how to do lookups and things like that. It isn't going to get into WHY you would want to do those things.
I didn't notice any major errors, in fact there were a lot fewer errors than I would expect. I'm glad this book was out there, it had been one of the more valuable IT books I've purchased.
If you need a quick overview book that helps generate some ideas for over coming problems, then I recommend this book. If you already have years of experience in SSIS by having SQL build packages for you, but have never explored the tools this is going to be a good book. If you are above beginner and have used Studio for your packages designs, you need a better tool then this book.
So for me this book gets 5 stars, because it gave me exactly what I needed, a starting place to let my imagination run wild.
Below are the top chapters in this book for me, not that the earlier chapters are not helpful also in explaining the tools, but starting at Section 4, my package designs changed completely.
Section IV: variables and Expressions
- This is something that is that is really simple now, but when first starting out I didn't use at all
Section V: Containers
Section VI: Configuration
- Configuring Child Packages, combine this with the variables chapter has change shorten the number of packages that I build. fewer packages = less trouble maintaining them.
section VII: Troubleshooting and Logging
- The basic building blocks to tracking problems. If you build fewer packages, you have more complex packages. This chapter helped in getting the basic down on creating a bug tracker.
In programming just knowing what someone is talking about opens up more ideas to explore with. I recommend combining this book with more advance books, web blogs, and MSN help files.
On a side note, I have people in the office look at the packages I'm building now and say "I didn't know you could do that."
Next step - custom controls so that I can build things faster.
The information in the book seems good otherwise. I am considering returning the Kindle Edition and ordering a hard copy which includes a DVD of the videos.