Microsoft SQL Server 2008 Integration Services Unleashed is the definitive, practical guide to the latest and most powerful version of SQL Server Integration Services (SSIS). Former SSIS product manager Kirk Haselden presents the deep insights you need to use SSIS to successfully integrate and manage information from virtually any data source. This new book is included for the first time in Sams' best-selling Unleashed series. In addition to covering all of SQL Server 2008 Integration Services' most important new features, Haselden has added more best practices, more tutorials, and more real-world examples. The result is a comprehensive, up-to-date guide that delivers both the hands-on help and the reliable reference information database professionals need. Drawing on his unique insider's insights into SSIS, Haselden covers enhancements in areas ranging from lookups to profiling, programming to scalability. Haselden starts with the simplest concepts, building on them step-by-step to help readers gain deep working mastery they can apply in enterprise projects. Simply put, no other book on SQL Server 2008 Integration Services is as thorough, as authoritative, or as useful. Product Description
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
Backcover
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
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
Microsoft SQL Server Integration Services is Microsoft
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
Backcover
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
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
Microsoft SQL Server Integration Services is Microsoft