Hands-On Microsoft SQL Server™ 2005 Integration Ser... and over one million other books are available for Amazon Kindle. Learn more


or
Sign in to turn on 1-Click ordering.
or
Amazon Prime Free Trial required. Sign up when you check out. Learn More
Sell Back Your Copy
For a $0.61 Gift Card
Trade in
More Buying Choices
Have one to sell? Sell yours here
Hands-On Microsoft SQL Server™ 2005 Integration Services
 
 
Start reading Hands-On Microsoft SQL Server™ 2005 Integration Ser... on your Kindle in under a minute.

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

Hands-On Microsoft SQL Server™ 2005 Integration Services [Paperback]

Ashwani Nanda (Author)
3.7 out of 5 stars  See all reviews (11 customer reviews)

List Price: $49.99
Price: $36.49 & this item ships for FREE with Super Saver Shipping. Details
You Save: $13.50 (27%)
  Special Offers Available
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
In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.
Only 6 left in stock--order soon (more on the way).
Want it delivered Tuesday, January 31? Choose One-Day Shipping at checkout. Details
Textbook Student FREE Two-Day Shipping for Students. Learn more

Formats

Amazon Price New from Used from
Kindle Edition $32.84  
Paperback $36.49  
Sell Back Your Copy for $0.61
Whether you buy it used on Amazon for $4.98 or somewhere else, you can sell it back through our Book Trade-In Program at the current price of $0.61.
Used Price$4.98
Trade-in Price$0.61
Price after
Trade-in
$4.37
There is a newer edition of this item:
Hands-On Microsoft SQL Server 2008 Integration Services, Second Edition Hands-On Microsoft SQL Server 2008 Integration Services, Second Edition 1.0 out of 5 stars (1)
$23.63
In Stock.

Book Description

0072263199 978-0072263190 August 28, 2006 1

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.


Special Offers and Product Promotions

  • Buy $50 in qualifying physical textbooks, get $5 in Amazon MP3 Credit. Here's how (restrictions apply)

Frequently Bought Together

Hands-On Microsoft SQL Server™ 2005 Integration Services + Microsoft SQL Server 2005 Reporting Services + Delivering Business Intelligence with Microsoft SQL Server 2005: Utilize Microsoft's Data Warehousing, Mining & Reporting Tools to Provide Critical Intelligence to A
Price For All Three: $97.57

Show availability and shipping details

Buy the selected items together


Editorial Reviews

From the Back Cover

Build robust, high-performance Business Intelligence solutions with SSIS

Extract, transform, and consolidate data from disparate sources and move it to single or multiple destinations using SQL Server 2005 Integration Services -- the next-generation data integration platform. Hands-On Microsoft SQL Server 2005 Integration Services shows you, step-by-step, how to build and manage SSIS packages, draw out meaningful information from raw data, and deliver de-duplicated and cleansed data to business applications and corporate reports. Inside, you'll get detailed information on migrating to SQL Server 2005 Integration Services, enhancing performance, and implementing encryption policies to secure SSIS packages.

ESSENTIAL SKILLS FOR DATABASE PROFESSIONALS:

  • Build packages with the SSIS Import and Export Wizard and BIDS
  • Create expressions using variables, functions, and operators
  • Lay out package workflow with Control Flow Containers and tasks
  • Secure SSIS packages and encrypt sensitive data
  • Monitor and audit runtime events using log providers
  • Respond to external triggers with event handlers
  • Transform and manipulate input using Data Flow Components
  • Standardize, de-duplicate, and cleanse data with Fuzzy Lookup and Fuzzy Grouping transformations
  • Load Data warehouse using Slowly Changing Dimension transformation
  • Deploy, optimize, troubleshoot, and debug SSIS packages

About the Author

Ashwani Nanda develops and maintains marketing, analytical, and CRM-based database systems for medium- to large-sized enterprises. His current area of specialization is data modeling, database management, data analysis, and visualization. He started his career on the real-time mainframe systems back in the age when hard disks used to weigh a kilo per megabyte. Moving from system engineering for mainframes to networking and infrastructure support and currently to data practice, he has worked for several major hardware and software vendors. He has loved to network and integrate disparate technologies, with particular attention to productivity and security. These days he is using his integration skills with RDBMS databases and end-user tools. He can be reached at ananda@AffordingIT.co.uk.


Product Details

  • Paperback: 570 pages
  • Publisher: McGraw-Hill Osborne Media; 1 edition (August 28, 2006)
  • Language: English
  • ISBN-10: 0072263199
  • ISBN-13: 978-0072263190
  • Product Dimensions: 9.1 x 7.4 x 1.2 inches
  • Shipping Weight: 2.1 pounds (View shipping rates and policies)
  • Average Customer Review: 3.7 out of 5 stars  See all reviews (11 customer reviews)
  • Amazon Best Sellers Rank: #851,764 in Books (See Top 100 in Books)

More About the Author

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

 

Customer Reviews

11 Reviews
5 star:
 (5)
4 star:
 (3)
3 star:    (0)
2 star:
 (1)
1 star:
 (2)
 
 
 
 
 
Average Customer Review
3.7 out of 5 stars (11 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

30 of 36 people found the following review helpful:
1.0 out of 5 stars Useless If you're Really Trying to Develop SSIS Integrations, November 9, 2006
This review is from: Hands-On Microsoft SQL Server™ 2005 Integration Services (Paperback)
Bought this book because it looked like it covered all the topics I needed to finish a project I was working on, but so far have yet to actually find an answer to a single question. This is one of those books that seem to plague the technical genre: it "alludes" to a particular topic, but never actually goes in-depth on anything.

Simply listing all the options available on a screen, while taking up lots of pages and creating an entry in the table of contents, doesn't make for a useful book. The examples provided were so superficial, I've got to wonder whether the author has actually done anything more than played with the software.

This one goes on the bookshelf with all the other "never to be picked up again" books. Too bad they're only of value to the paper recyclers.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


9 of 10 people found the following review helpful:
5.0 out of 5 stars Hands On Throughout the Entire Book, March 16, 2007
This review is from: Hands-On Microsoft SQL Server™ 2005 Integration Services (Paperback)
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.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


4 of 4 people found the following review helpful:
2.0 out of 5 stars Good starter book, February 15, 2008
By 
Walter Boyd (Fairview, TX, USA) - See all my reviews
(REAL NAME)   
This review is from: Hands-On Microsoft SQL Server™ 2005 Integration Services (Paperback)
This book helped me get started with SSIS...figure out some basic stuff. But it left me hanging on the details, best practices, integration with applications, etc. It basically walks you through building a bunch of thin-functionality examples of the various components.

If the book re-described itself as a getting-started book, I'd give it high praise and more stars...but the phrases "in depth", "learn to maximize", "extensive", etc, should have been omitted from the book description.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No

Share your thoughts with other customers: Create your own review
 
 
 
Most Recent Customer Reviews









Only search this product's reviews



Inside This Book (learn more)
Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
available input columns, file connection manager, data flow task, data flow destination, new output column, data conversion transformation, data flow engine, integration services data flow, lookup transformation, migrated package, derived column transformation, mailing opportunities, data flow sources, database level roles, sysdtspackages table, this connection manager, flat file destination, end execution tree, type data viewer, control flow surface, conditional split transformation, dimension processing destination, raw file destination, raw file source, slowly changing dimension transformation
Key Phrases - Capitalized Phrases (CAPs): (learn more)
Server Management Studio, Solution Explorer, Cancel Help Figure, Server Agent, Address Line, Importing Contacts, Cancel Figure, Upgrade Advisor, Package Explorer, Loading Vehicle, Books Online, Package Migration Wizard, Error List, Visual Basic, Iterating May Opportunities, Back Next, Packages Store, Visual Studio, Hit Count, Stored Packages, United Kingdom, Configure Error Output, Business Intelligence Development Studio, Destination Editor, Execute Process
New!
Books on Related Topics | Concordance | Text Stats
Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Surprise Me!
Search Inside This Book:




Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
 

Your tags: Add your first tag
 

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 


Active discussions in related forums
Search Customer Discussions
Search all Amazon discussions
   
Related forums



So You'd Like to...


Create a guide


Look for Similar Items by Category


Look for Similar Items by Subject