Microsoft SQL Server 2005 Integration Services Step by Step

Microsoft SQL Server 2005 Integration Services Step by Step

NOOK Book(eBook)

$26.99 $35.99 Save 25% Current price is $26.99, Original price is $35.99. You Save 25%.

Available on Compatible NOOK Devices and the free NOOK Apps.
WANT A NOOK?  Explore Now

Overview

Teach yourself the fundamentals of SQL Server Integration Services—one step at a time. This practical, learn-by-doing tutorial delivers the guidance you need to transform and consolidate data—and build solutions that support your business intelligence needs.

Discover how to:

  • Design and execute packages that transform data between files and relational databases
  • Configure connection managers to access other data sources
  • Create data flows that alter, split, match, and merge data
  • Develop event-handlers and monitor package performance
  • Encrypt sensitive information and control access to packages
  • Customize script code to automate Control Flow and Data Flow tasks
  • Debug, troubleshoot, and optimize packages

CD features:

  • All practice exercises
  • Sample databases
  • Fully searchable eBook

For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

Product Details

ISBN-13: 9780735646308
Publisher: Pearson Education
Publication date: 06/20/2007
Series: Step by Step Developer
Sold by: Barnes & Noble
Format: NOOK Book
Pages: 480
File size: 17 MB
Note: This product may take a few minutes to download.

About the Author

Paul Turley, Joe Kasprzak, Scott Cameron, Satoshi Iizuka, and Pablo Guzman are each business intelligence experts who work for Hitachi Consulting.

Table of Contents

Introduction

Getting Started with Integration Services

Chapter 1: Introduction to SQL Server Integration Services

Chapter 2: Building Your First Package

Designing Packages

Chapter 3: Extracting and Loading Data

Chapter 4: Using Data Flow Transformations

Chapter 5: Managing Control Flow

Chapter 6: Scripting Tasks

Chapter 7: Debugging Packages

Chapter 8: Managing Package Execution

Managing Packages

Chapter 9: Detecting and Handling Processing Errors

Chapter 10: Securing and Deploying SSIS Packages

Chapter 11: Optimizing SSIS Packages

Applying SSIS to Data Warehousing

Chapter 12: Data Warehouse Concepts

Chapter 13: Populating Data Warehouse Structures

Chapter 14: SSIS General Principles

About the Authors

For Web Developers

Additional SQL Server Resources for Developers

Customer Reviews