Microsoft® SQL Server(TM) 2005 Integration Services Step by Step [Paperback]

Paul Turley (Author), Joe Kasprzak (Author), Scott Cameron (Author), Satoshi Iizuka (Author), Pablo Guzman (Author), Hitachi Consulting (Author)

Book Description

Publication Date: June 20, 2007

Teach yourself the fundamentals of SQL Server Integration Services—one step at a time. This practical, learn-by-doing tutorial delivers the guidance you need to transform and consolidate data—and build solutions that support your business intelligence needs.

Discover how to:

• Design and execute packages that transform data between files and relational databases
• Configure connection managers to access other data sources
• Create data flows that alter, split, match, and merge data
• Develop event-handlers and monitor package performance
• Encrypt sensitive information and control access to packages
• Customize script code to automate Control Flow and Data Flow tasks
• Debug, troubleshoot, and optimize packages

CD features:

• All practice exercises
• Sample databases
• Fully searchable eBook

A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to [e-mail].

Editorial Reviews

From the Publisher

Key Book Benefits:

-Provides hands-on exercises that help develop proficiency quickly

-Features expertise from Hitachi Consulting, which creates specialized SQL Server-based data solutions for corporate customers

-Includes a companion CD with sample data sets and code

About the Author

Paul Turley manages the development of training solutions for business intelligence and enterprise reporting at Hitachi Consulting. He has authored several training courses and books on database design, SQL Server, Analysis Services, and Reporting Services.

Hitachi Consulting, a division of Hitachi Ltd., is a global business and IT consulting firm serving Fortune 2000 companies. It is a leader in developing corporate training and custom solutions for business intelligence and other strategic business needs.

Product Details

• Paperback: 480 pages
• Publisher: Microsoft Press (June 20, 2007)
• Language: English
• ISBN-10: 0735624054
• ISBN-13: 978-0735624054
• Product Dimensions: 9 x 7.3 x 1.2 inches
• Shipping Weight: 2.2 pounds (View shipping rates and policies)
• Average Customer Review: 2.8 out of 5 stars  See all reviews (10 customer reviews)
• Amazon Best Sellers Rank: #323,167 in Books (See Top 100 in Books)
  • #54 in Books > Computers & Technology > Databases > Relational Databases

More About the Author

Paul Turley (Vancouver, WA) is a Manager of Specialized Services for Hitachi Consulting External Education Services. Paul manages the Business Intelligence training team and teaches classes for companies throughout the world on Microsoft SQL Server technologies. He works with companies to architect and build BI and reporting solutions.
He has been developing business database solutions since 1991 for companies like Microsoft, Disney, Nike and Hewlett-Packard. He has been a Microsoft Certified Trainer since 1996 and holds several industry certifications including MCTS and MCITP for BI, MCSD, MCDBA, MSF Practitioner and IT Project+.
Paul has authored and co-authored several books and courses on database, business intelligence and application development technologies. He is the lead courseware developer for the Hitachi Consulting courses: SQL Server 2008 Business Intelligence Solutions and SQL Server 2008 Reporting Services Solutions. Books include Professional SQL Server 2008 Reporting Services, Professional SQL Server 2005 Reporting Services, Professional SQL Server Reporting Services (SQL Server 2000,) Beginning Transact-SQL with SQL Server 2000 and 2005, Beginning SQL Server 2005 Administration, Beginning Access 2002 VBA, Data Warehousing with SQL Server 2000 Analysis Services, and Professional Access 2000 Programming ' from Wrox Press. He is also a contributing author for SQL Server 2005 Integration Services Step by Step from Microsoft Press.

Customer Reviews

Most Helpful Customer Reviews

3 of 3 people found the following review helpful:

1.0 out of 5 stars Book not thoroughly reviewed!, May 7, 2008

By 

FCG "FCG" (Singapore) - See all my reviews

This review is from: Microsoft® SQL Server(TM) 2005 Integration Services Step by Step (Paperback)

I agree witht the previous readers that the book was hastely done without any thought for quality! A lot of examples from the book differ drastically with the examples in the cd.(and even with the electronic copy of the book that came w/ the cd!)

I tried to salvage the situation by visiting MS Press for some errata announcements, but i was even more confused in the web-maze that they hyperlinked me to.... to no avail (surprise, surprise!)

If you have a limited budget on reference books... dont buy this one.

5 of 6 people found the following review helpful:

4.0 out of 5 stars It was not that bad at all, October 11, 2007

By 

Akash Aggarwal (Cincinnati, OH United States) - See all my reviews
(REAL NAME)   

This review is from: Microsoft® SQL Server(TM) 2005 Integration Services Step by Step (Paperback)

if you are a first time visitor to SSIS, I think its a good book. It could definitely have been better but if you need to really practice on real life scenarious, it covers them well. There might be some instructions here and there which do not exactly mirror to the latest version and not sure if those were typos vs beta version but since the SSIS interface is so intuitive it's not as bad and this book really gets you upto speed in very short time.
If you are a totally new to the SSIS world, I would recommend it.

4 of 5 people found the following review helpful:

4.0 out of 5 stars Review of Step By Step, December 28, 2007

By 

K. Lee (Melbourne, Australia) - See all my reviews
(REAL NAME)   

This review is from: Microsoft® SQL Server(TM) 2005 Integration Services Step by Step (Paperback)

I found this book to be quite informative. Given that I am a first timer to SSIS, there were some useful examples. There could have been more substance around the Datawarehousing part of the book. The examples provided on the CD were shockingly packaged. There were files missing and incorrect CD's. This is disappointing given that I bought this book because it was a Microsoft Press publishing.