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

by Paul Turley (Author), Joe Kasprzak (Author), Scott Cameron (Author), Satoshi Iizuka (Author), Pablo Guzman (Author), Hitachi Consulting (Author)
Key Phrases: script task, connection managers, data source views, Data Flow, Control Flow, Solution Explorer (more...)

Editorial Reviews

Product Description
Get hands-on, practical guidance for using Microsoft SQL Server Integration Services, the next generation data integration platform from Microsoft. Integration Services is a powerful tool for business intelligence, so understanding the essentials--how to develop and deploy SSIS packages, as well as how to apply these skills to data warehousing solutions--is critical to harnessing the full benefits of SQL Server. This step-by-step tutorial teaches you all the essentials for getting started, including data transformation, scripting, security, and best practices for developing enterprise-class data integration applications. With STEP BY STEP, you work at your own pace through hands-on, learn-by-doing exercises. Whether you're a beginning programmer or new to this version of the technology, you'll understand the fundamental techniques for using SQL Server 2005 Integration Services. A companion CD includes data sets and sample code.

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

See all Editorial Reviews

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.3 inches
• Shipping Weight: 2.2 pounds (View shipping rates and policies)
• Average Customer Review: 2.7 out of 5 stars See all reviews (9 customer reviews)
• Amazon.com Sales Rank: #325,407 in Books (See Bestsellers in Books)

Customer Reviews

Most Helpful Customer Reviews

5 of 5 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)

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 4 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)

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.

4 of 4 people found the following review helpful:

5.0 out of 5 stars A great SQL Server Integration Services book for beginners, October 23, 2007

By	Yue Jiang "johnyue" - See all my reviews (REAL NAME)

I have a project to create a data warehouse, ETL the data and report from the new data warehouse. I have no SQL server 2005 experience at all. But after I read this book and follow the book step by step. I was able to create my DW ETL data to corresponding DIM and Fact tables and created my reports from my DW correctly without any problem. This book has very clear concepts and very practical steps. If you like to learn-by-doing on SSIS. This is the book does it all.