Overview

Microsoft SQL Server Integration Services is Microsoft’s powerful platform for building enterprise-level data integration and data transformation solutions. It’s a powerful product, but it’s also complex and can be confusing if you don’t have a clear map for the journey. Microsoft SQL Server 2008 Integration Services Unleashed will be the only book you’ll need to harness the power that Integration Services provides.   Through clear, concise explanations and samples, you’ll grasp a clear understanding of working in the Integration Services environment, including how to set up stock components, how to use the various designer features, and how to gain practical knowledge on configuring, deploying, securing, and managing packages. Sample packages are provided to reinforce the discussion and quickly help you gain hands-on experience, and more complex topics such as Data Flow Task internals and tuning, advanced transformations, and writing custom components are all illustrated in easy-to-understand graphics. In addition, there are several custom tasks and transformations and two useful utilities with full source code available for you to use and study, including an ADO.NET destination, a text file encryption task, and a data profiling transform.   Detailed information on: Using the powerful Integration Services tools to create solutions without the need to write lines of code Creating packages programmatically or developing custom tasks via the Integration Services object Building robust packages to solve common requirements Securing packages for different environments Using often overlooked or unknown platform features Setting up all the stock components, including data flow components, tasks, Foreach enumerators, connection managers, and log providers Writing robust and useful custom tasks Building packages that seamlessly deploy to other environments Writing custom data flow adapters and transforms Using script tasks and components Easily modifying configurations for multiple packages simultaneously Writing a Task UI that looks just like the stock tasks Tapping into the power of Integration Services for accessing heterogeneous data sources Using expressions to make packages more responsive to the environment Migrating your DTS packages with no stress   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, as well as many of the tasks. 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.   Category: Microsoft SQL Server Covers: Microsoft SQL Server 2008 Integration Services User Level: Intermediate—Advanced   $59.99 US / $71.99 CAN / £38.99 Net UK  

Full Product Details

Author:   Kirk Haselden
Publisher:   Pearson Education (US)
Imprint:   Sams Publishing
Dimensions:   Width: 17.90cm , Height: 4.50cm , Length: 23.00cm
Weight:   1.295kg
ISBN:  

9780672330322

ISBN 10:   0672330326
Pages:   792
Publication Date:   26 February 2009
Audience:   Professional and scholarly ,  Professional & Vocational
Format:   Paperback
Publisher's Status:   Out of Print
Availability:   In Print  
Limited stock is available. It will be ordered for you and shipped pending supplier's limited stock.

Table of Contents

      PART I: Getting Started 1              What is Integration Services and why do I need it? 2              Setting Up Integration Services 3              Migrating from DTS or SSIS 2005 4              What's New in 2008? PART II: Integration Services Basics 5              The Business Intelligence Development Studio 6              The Building Blocks of Integration Services 7              Grouping Control Flow with Containers 8              Building a Package-Quick Start PART III: Control Flow Services 9              The Venerable Variable 10            Using Expressions 11            The Stock Tasks and Connection Managers 12            Using The Script Task 13            Using the Data Profiling Task 14            Logging and the Stock Log Providers 15            Looping and Foreach Enumerators PART IV: Management Services 16            SQL Server Management Studio 17            Using Source Control 18 Securing Packages PART V: The Data Flow Task 19            Introducing the Data Flow Task 20            The Stock Data Flow Components 21 The Script Component 22            Advanced Data Flow Transformations 23            Data Flow Task Internals and Tuning PART VI: Solving Common Challenges 24            Configuring and Deploying Packages 25            Common Challenges (Tips and Tricks) PART VII: Advanced Package Concepts and Patterns 26            Troubleshooting packages 27            Building Advanced Packages PART VIII: Programming Integration Services 28            Building Custom Tasks 29            Building Custom Data Flow Components  

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 longterm 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 bachelor of arts degree 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