Microsoft SQL Server 2008 Integration Services Unleashed
Product Author Bios
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.
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
4 of 4 people found the following review helpful
Amazon Verified Purchase(What's this?)
This review is from: Microsoft SQL Server 2008 Integration Services Unleashed (Kindle Edition)This would be more properly titled a "Reference Manual" and most of what's in it could probably be picked up from the web. It's a long list of what's in SSIS with short explanations of each item and very little how-to. There are very few examples and mostly they are not helpful.
For example, the section on the Flat File Connection Manager has an example of sorts... is this an input file? Output file? How did those column names get there? Can column names be passed along the dataflow path? How do I actually connect the inputs from the flat file to the object I'm trying to load or extract?
I see the price has dropped by $12 or so to about $20 since I purchased it... I still wouldn't recommend it unless you just wanted a list of what's in SQL Server.
I had an excellent book on DTS that really helped launch my use of that tool and this book is, in contrast, a huge disappointment. It's hardly helping me use SSIS at all.
3 of 3 people found the following review helpful
I regret this purchase,
This review is from: Microsoft SQL Server 2008 Integration Services Unleashed (Paperback)I do not find this book at all useful. I am trying to get started using SSIS, and this book just didn't cut it. There are very few (1?) examples, and it does nothing to start you at the basics and then develop upon that. When you thumb through the pages, it looks and reads like they've cut-and-paste BOL.
It might be alright if you already had a basic understanding, and just needed a quick reference. However I am getting nowhere with this book. I suggest that this is not a very good starting place.
6 of 8 people found the following review helpful
Buen libro de principio a fin (Good book from start to finish),
This review is from: Microsoft SQL Server 2008 Integration Services Unleashed (Paperback)En el libro SQL Server 2008 Integration Services, Kirk Haselden hace un buen trabajo al proveer una basta explicación de principio a fin de lo que es Integration Services y para que utilizarlo. El autor utiliza una gran cantidad de ejemplos que están disponibles para bajar en la página del libro ([...]) para demostrar sus conceptos.
Hasta los lectores con menos experiencia o que se estén moviendo de DTS a SSIS encontraran una clara explicación de la nuevas funcionalidades existentes en SQL Server 2008 (como mejoras al "Data Flow Task", mejor experiencia en la creación de Scripts en VB y C#, "Data Profiling Task", etc...)
El autor nos lleva desde la instalación, mejores prácticas de la migración de DTS a SSIS, los conceptos básicos de SSIS, creación de packetes, manejo de variables y manejo de eventos hasta el desarrollo de componentes "custom" en el caso de que los componentes que son... Read more
› See all 7 customer reviews...
Online Sample Chapter
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
Book + eBook Bundle
Book Price $47.99
eBook Price $16.80
eBook formats included
This book includes free shipping!
This book includes free shipping!
Includes EPUB, MOBI, and PDF
About eBook Formats
This eBook includes the following formats, accessible from your Account page after purchase:
EPUBThe open industry format known for its reflowable content and usability on supported mobile devices.
MOBIThe eBook format compatible with the Amazon Kindle and Amazon Kindle applications.
PDFThe popular standard, used most often with the free Adobe® Reader® software.
This eBook requires no passwords or activation to read. We customize your eBook by discretely watermarking it with your name, making it uniquely yours.
Get access to thousands of books and training videos about technology, professional development and digital media from more than 40 leading publishers, including Addison-Wesley, Prentice Hall, Cisco Press, IBM Press, O'Reilly Media, Wrox, Apress, and many more. If you continue your subscription after your 30-day trial, you can receive 30% off a monthly subscription to the Safari Library for up to 12 months. That's a total savings of $199.