SQL Server 2005 Books

 Location:  Home > Integration Services (SSIS) > Hands-On Microsoft SQL Server 2005 Integration Services  

Hands-On Microsoft SQL Server 2005 Integration Services

Hands-On Microsoft SQL Server 2005 Integration ServicesAuthor: Ashwani Nanda
Publisher: McGraw-Hill Osborne Media
Category: Book

List Price: $49.99
Buy Used: $16.97
as of 9/10/2010 19:03 CDT details
You Save: $33.02 (66%)



New (24) Used (24) from $16.97

Seller: thrift_books
Rating: 4.0 out of 5 stars 10 reviews
Sales Rank: 624956

Media: Paperback
Edition: 1
Pages: 570
Number Of Items: 1
Shipping Weight (lbs): 2.1
Dimensions (in): 9 x 7.4 x 1.4

ISBN: 0072263199
Dewey Decimal Number: 005.7585
EAN: 9780072263190
ASIN: 0072263199

Publication Date: August 28, 2006
Availability: Usually ships in 1-2 business days

Also Available In:

  • Kindle Edition - Hands-On Microsoft SQL Server 2005 Integration Services

Similar Items:


Editorial Reviews:

Product Description

In-depth coverage of Microsoft’s powerful new data integration tool

Learn to maximize the features of SQL Server 2005 Integration Services from this essential guide. Hands-On Microsoft SQL Server 2005 Integration Services makes learning SSIS easy through the use of extensive real-world exercises structured around every component within the tool. You will learn to collect corporate data from various sources and transform that data for analysis, mining, and reporting.




Customer Reviews:
Showing reviews 1-5 of 10



5 out of 5 stars Hands On Throughout the Entire Book   March 16, 2007
tmeister
8 out of 9 found this review helpful

The title for this book is true, it is Hands-On. Some books just rehash the SQL Books Online but this one provides tons of hands on excercises. Here are just a few.
Importing a Flat File into SQL Server 2005
Using System Variables to Create Custom Logs
Using Expressions to Update Properties at Run-time
Contacting Opportunities (Includes steps necessary for enabling SMTP from a package)
Removing Duplicate Email Addresses
Consolidating Workflow Packages
Reading the Application Log
Managing Storage of Integration Services Package
Using dtutil
Running an SSIS Package Using the Package Execution Utility
Understanding Package Protection Levels

Beyond the Hands On Exercises the book also is based around a database other than the standard Northwind, pubs or AdventureWorks databases for a little variety. Finally the book covers deployment of your Integration Services Packages and also how to migrate from SQL Server 2000 Data Transformation Services.



5 out of 5 stars Great Book to learn SSIS Quickly   April 23, 2007
Madhusudana Isanaka (Boston,USA)
7 out of 8 found this review helpful

Hi All,

I bought this book because i need to implement my project in SSIS.This book is good for on Job reference , for Beginners and For who has exposure to DTS 2000.I learned and implemented my projected with no time.I recommend this book for those who want to Know about SSIS Quickly.

Thanks,
Madhu



5 out of 5 stars Half-star off for a questionable title, but beyond that, a gem for those new to SSIS   May 1, 2008
Kevin S. Goff (Pennsylvania, USA)
3 out of 4 found this review helpful

There is no question that the title should clearly indicate that this is a book for those new to SSIS. (And considering SSIS is such a quantum leap from DTS, there are MANY folks at that stage).

However, the book deserves 4-5 stars for what it provides. Giving the book 1-star, because of the title, detracts from the true value of the book. There aren't many books that contain full hands-on exercises. If someone is fairly new to SSIS, THIS is the book to get.

This is the closest I've seen to an exercise-driven training manual, in commercial trade paperback form. There are a series of 8-10 page walk-throughs on such topics as aggregation, processing dupes, loading SCDs, pivoting source data, ADO enumerators, etc.

In my opinion, the entire Database Professional Series from Osborn McGraw Hill is very strong.

If someone already knows the fundamentals of SSIS and wants to go to the next level, get the Wrox Expert SSIS book.

Kevin



5 out of 5 stars Great book, like a personal tutor   January 26, 2009
S. Bangera (Parsippany,NJ)
0 out of 1 found this review helpful

This book chapter by chapter teaches you fundamental concept and follows it up by practical application of what you have learned. The result is that you are in tune with the SSIS each progressing chapter and confident of applying that at your workplace. By devoting most of the pages to hands on exercise, the author does not sacrifice valuable technical concepts and definitions, thus book also serves as a reference book. I recommend such books written by actual professionals than 600+ page book of just theory which leaves the practical application to the imagination of reader.


5 out of 5 stars Good Book   October 8, 2007
Krishna Sonti (Florida)
0 out of 5 found this review helpful

This book is a good one. It brings a new SSIS user to speed quickly. The author has done a good job.

Showing reviews 1-5 of 10


CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED ‘AS IS’ AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.
Copyright 2008, SQL Server 2005 Books. All Rights Reserved. In association with Amazon.com