Microsoft SQL server 2005 integration services

Format:

Book

Author/Creator:

Haselden, Kirk, Author.

Language:

English

Subjects (All):

SQL server.

Client/server computing.

Physical Description:

1 online resource (888 pages)

Edition:

1st edition

Other Title:

Integration services

Place of Publication:

[Place of publication not identified] Sams 2006

Language Note:

English

System Details:

text file

Summary:

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, providing you with true enterprise extract transform and load features (ETL). Microsoft SQL Server 2005 Integration Services concentrates on providing you with real world solutions to real world problems, giving you a head start on various projects. If you are only evaluating Integration Services, you'll be able to focus on the early chapters with the option of drilling down into details in the later chapters where some of the more complex concepts will be discussed in detail. The interesting sidebars peppered throughout the book provide insight into the processes, people and decisions that yielded the final IS product.

Contents:

Intro

Title Page

Copyright Page

Contents at a Glance

Table of Contents

Foreword

About the Author

Acknowledgments

We Want to Hear from You!

PART I. Getting Started

Chapter 1. Welcome to SQL Server Integration Services 2005

Chapter 2. Setting Up Integration Services

Chapter 3. Migrating from DTS

Chapter 4. Building a Package-Quick Start

PART II. Integration Services Basics and Concepts

Chapter 5. The Business Intelligence Development Studio

Chapter 6. The Building Blocks of Integration Services

Chapter 7. Grouping Control Flow with Containers

PART III. Control Flow Services

Chapter 8. The Stock Tasks

Chapter 9. Using Expressions

Chapter 10. The Stock Connection Managers

Chapter 11. Logging and the Stock Log Providers

Chapter 12. The Venerable Variable

Chapter 13. Looping and Foreach Enumerators

PART IV. Management Services

Chapter 14. Configuring and Deploying Solutions

Chapter 15. Using The Script Task

Chapter 16. Using Source Control

Chapter 17. SQL Server Management Studio

Chapter 18. Securing Packages

PART V. The Data Flow Task

Chapter 19. Introducing the Data Flow Task

Chapter 20. The Stock Data Flow Components

Chapter 21. Using the Script Component

Chapter 22. Advanced Data Flow Transformations

Chapter 23. Data Flow Task Internals and Tuning

PART VI. Programming Integration Services

Chapter 24. Building Custom Tasks

Chapter 25. Building Custom Data Flow Components

Appendix A. Error, Warning, and Information Events

Appendix B. Expression Evaluator Reference Sheet

Index.

Notes:

Bibliographic Level Mode of Issuance: Monograph

Description based on publisher supplied metadata and other sources.

ISBN:

9786610848744

9780768689983

0768689988

9781280848742

128084874X

9780768666830

076866683X

OCLC:

1027144856