Microsoft SQL Server 2005 Integration Services

Overview

All medium to large companies have to deal with data being stored in a number of databases, spreadsheets and proprietary applications. Bringing all this data together into one system can be useful to analyzing the business; but can also be quite difficult to do. Integration Services is the next big bet in Microsoft's business intelligence lineup, providing you with true enterprise extract transform and load features (ETL).

Microsoft SQL Server 2005 Integration ...

See more details below
Available through our Marketplace sellers.
Other sellers (Paperback)
  • All (20) from $1.99   
  • New (6) from $2.99   
  • Used (14) from $1.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$2.99
Seller since 2007

Feedback rating:

(182)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
Brand New. Remainder mark. Ship daily. Pack carefully. E-mail when shipped. 6BB -- $1 OFF IF YOU BUY 2 OR MORE BOOKS. USE CODE TVHQ68XV

Ships from: Denver, CO

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
$27.71
Seller since 2008

Feedback rating:

(173)

Condition: New
0672327813

Ships from: fallbrook, CA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
$41.26
Seller since 2008

Feedback rating:

(18019)

Condition: New
Brand New, Perfect Condition, Please allow 4-14 business days for delivery. 100% Money Back Guarantee, Over 1,000,000 customers served.

Ships from: Westminster, MD

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
$41.27
Seller since 2007

Feedback rating:

(23678)

Condition: New
BRAND NEW

Ships from: Avenel, NJ

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
$54.76
Seller since 2009

Feedback rating:

(132)

Condition: New
New Book from multilingual publisher. Shipped from UK in 10 to 14 business days.

Ships from: Fairford, United Kingdom

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
$69.68
Seller since 2014

Feedback rating:

(6)

Condition: New
New

Ships from: Idyllwild, CA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Microsoft SQL Server 2005 Integration Services

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK 7.0
  • Samsung Galaxy Tab 4 NOOK 10.1
  • NOOK HD Tablet
  • NOOK HD+ Tablet
  • NOOK eReaders
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac

Want a NOOK? Explore Now

NOOK Book (eBook)
$29.99
BN.com price
(Save 42%)$51.99 List Price

Overview

All medium to large companies have to deal with data being stored in a number of databases, spreadsheets and proprietary applications. Bringing all this data together into one system can be useful to analyzing the business; but can also be quite difficult to do. Integration Services is the next big bet in Microsoft's business intelligence lineup, providing you with true enterprise extract transform and load features (ETL).

Microsoft SQL Server 2005 Integration Services concentrates on providing you with real world solutions to real world problems, giving you a head start on various projects. If you are only evaluating Integration Services, you'll be able to focus on the early chapters with the option of drilling down into details in the later chapters where some of the more complex concepts will be discussed in detail. The interesting sidebars peppered throughout the book provide insight into the processes, people and decisions that yielded the final IS product.

Read More Show Less

Product Details

  • ISBN-13: 9780672327810
  • Publisher: Sams
  • Publication date: 8/4/2006
  • Series: SQL Server Series
  • Pages: 717
  • Product dimensions: 7.10 (w) x 9.22 (h) x 1.92 (d)

Meet the Author

Kirk Haselden is the Group Program Manager for the Microsoft Master Data Management product forthcoming in the next wave of Office SharePoint Services and owns the long term strategy, vision, planning and development of that product. Kirk has been with Microsoft for 12 years in various groups including Hardware, eHome, Connected Home, SQL Server and Office Business Platform. He was the development manager for Integration Services and the primary designer for the runtime and many of the tasks. Prior to Microsoft, Kirk worked for several small startup companies building educational, dental and online software. Kirk has a BA in Accounting and Information Systems from the University of Utah. He has written a number of articles for SQL Server Magazine, speaks regularly at industry events, writes profusely on his personal and MSDN blog, and holds 35 patents or patents pending. Kirk is married and the father of five wonderful children. He enjoys family time, photography, snow skiing, wake boarding, racquetball, motorcycle riding, hiking, breathing, drinking, and eating. He’s always wearing hideous Hawaiian shirts, shorts, and sandals, except in the winter, when he also wears socks. He once lived in Wichita, Kansas and thinks it’s funny when people talk about themselves in third person.

Read More Show Less

Read an Excerpt

ForewordForeword

Microsoft SQL Server 7.0 and SQL Server 2000 both contained a component called Data Transformation Services (DTS). DTS was an ETL tool. If you don't already know that ETL means Extract, Transform and Load, this might not be the book for you. But if you do care about ETL, have challenging ETL problems, and have SQL Server 2005, this most likely is the book for you! This book is about SQL Server 2005 Integration Services, the successor to DTS.

It took a unique team to build SQL Server 2005 Integration Services. If I had told you in 2000 when we started the Integration Services project that we would assemble a team of almost 30 people at Microsoft who were utterly passionate about ETL, you would have been skeptical. Through the leadership of Kamal Hathi, Donald Farmer, Eduardo Alvarez-Godinez, and your author Kirk Haselden, we did just that.

When we began planning "Yukon" (which became SQL Server 2005), we knew that our customers were facing ever larger and more challenging ETL problems. Years ago, data warehousing and business intelligence were "local" problems; or perhaps better said as "solutions to local problems."—the sales warehouse sourced answers to questions in the sales department, and marketing had its own warehouse. True performance management, the evolution of business intelligence, however, requires a complete company view. Customers want to load far more data than in the past, and they want to do so far more frequently.

We knew it was time to reinvent our ETL tool. We wanted to increase performance by at least an order of magnitude. We wanted to incorporate best-of-class ease of use, unparalleledprogrammability, and a very high level of out-of-the-box functionality. We truly sought to reinvent our ETL offering. Thinking about who in our industry really knew how to push a lot of processing against a lot of data, I sought out programmers and architects from the compiler team. We were lucky to find Mike Blaszczak, who had made key contributions to MFC, and who is one of the best programmers in the world. Mike in turn knew Kirk, and brought him into the team early on. In just a few years, Kirk became the Development Manager for Integration Services, and with his team, brought it to market.

This makes Kirk an ever-so appropriate guide for you in your exploration and use of Integration Services. He of course has a deep understanding of SSIS at every level—we expect that from a Development Manager. Beyond that, he has a love for users and customers that translates into a clear writing style and an enjoyable read. In each chapter, Kirk motivates you, teaches you, and delivers insight only a "Dev Manager" would possess. Pay attention to the notes in various chapters: This is where you get to see into the mind of the developer. Also, pay attention to the quotes that open each chapter—I can verify many of these, I was there to hear them, and they are often entertaining.

One of the ways in which SSIS improves on DTS is in manageability. The "configuration" is a new concept in SSIS. Configurations allow ETL developers to put some of the metadata of their package on the outside of the package, so that administrators can tweak them at deployment time. Chapter 14, "Configuring and Deploying Solutions," covers this in detail. Chapter 23, "Data Flow Task Internals and Tuning," covers optimization and tuning. SSIS can handle enterprise ETL needs, and this chapter gives you the insight and details you need to run your SSIS packages at their fullest performance.

Another area of difference between DTS and SSIS is extensibility. Chapter 24, "Building Custom Tasks," covers the development of custom tasks. Chapter 25, "Building Custom Data Flow Components," covers the development of custom components. The companion website at http://www.samspublishing.com includes all of the source code that Kirk develops in these chapters. I'm personally looking forward to using his source component to pull EXIF information out of JPEG files: Kirk is an avid photographer and has used real-world examples throughout the book.

It's been a privilege to work with Kirk for several years. I hope to work with him for years to come. He worked hard on this book because he loves SSIS and its customers. I hope you enjoy his work and profit from this book.

Bill Baker
May 2006, Redmond, WA

© Copyright Pearson Education. All rights reserved.

Read More Show Less

Table of Contents

Pt. I Getting started
1 Welcome to SQL Server integration services 2005 3
2 Setting up integration services 9
3 Migrating from DTS 19
4 Building a package - quick start 35
Pt. II Integration services basics and concepts
5 The business intelligence development studio 55
6 The building blocks of integration services 103
7 Grouping control flow with containers 113
Pt. III Control flow services
8 The stock tasks 139
9 Using expressions 191
10 The stock connection managers 205
11 Logging and the stock log providers 243
12 The venerable variable 261
13 Looping and foreach enumerators 275
Pt. IV Management services
14 Configuring and deploying solutions 299
15 Using the script task 331
16 Using source control 353
17 SQL server management studio 367
18 Securing packages 389
Pt. V The data flow task
19 Introducing the data flow task 415
20 The stock data flow components 423
21 Using the script component 489
22 Advanced data flow transformations 507
23 Data flow task internals and tuning 537
Pt. VI Programming integration services
24 Building custom tasks 563
25 Building custom data flow components 621
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)