Microsoft SQL Server 2005 Integration Services

Author:   Kirk Haselden ,  Kirk Haselden
Publisher:   Pearson Education (US)
ISBN:  

9780672327810


Pages:   744
Publication Date:   03 August 2006
Format:   Paperback
Availability:   In Print   Availability explained
Limited stock is available. It will be ordered for you and shipped pending supplier's limited stock.

Our Price $171.57 Quantity:  
Add to Cart

Share |

Microsoft SQL Server 2005 Integration Services


Add your own review!

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. It provides true enterprise extract transform and load features (ETL). Analysts estimate that up to 80 percent of business intelligence system costs are expended on ETL processing. Integration Services makes implementing ETL processes simpler by virtually eliminating the need for custom coded solutions, thereby saving time and money. Integration Services also provides a rich development environment that's well integrated with Analysis Services and Reporting Services (both of which have proved to be very popular among database developers in 2004). Integration Services makes true enterprise level business intelligence more accessible to the masses. This book will concentrate on providing real world solutions to real world problems giving readers a head start on their various projects. Some readers may only be evaluating Integration Services and will just want to know the basics and the early chapters will provide those with the option of drilling down into details in the later chapters where some of the more complex concepts will be discussed in detail.

Full Product Details

Author:   Kirk Haselden ,  Kirk Haselden
Publisher:   Pearson Education (US)
Imprint:   Sams Publishing
Dimensions:   Width: 23.20cm , Height: 4.10cm , Length: 17.80cm
Weight:   1.352kg
ISBN:  

9780672327810


ISBN 10:   0672327813
Pages:   744
Publication Date:   03 August 2006
Audience:   College/higher education ,  Tertiary & Higher Education
Format:   Paperback
Publisher's Status:   Out of Print
Availability:   In Print   Availability explained
Limited stock is available. It will be ordered for you and shipped pending supplier's limited stock.

Table of Contents

Contents at a Glance Part 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 Part 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 Part 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 Part 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 Part 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 Part VI: Programming Integration Services     24    Building Custom Tasks    563     25    Building Custom Data Flow Components    621         Index    661

Reviews

Author Information

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.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions
Latest Reading Guide

MRG2025CC

 

Shopping Cart
Your cart is empty
Shopping cart
Mailing List