Microsoft SQL Server 2005 Integration Services

Kirk Haselden

720 pages, parution le 29/09/2006

Ajouter à une liste

Indisponible

Résumé

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.

L'auteur - Kirk Haselden

Kirk Haselden is the Development Manager on the Integration Services team. Kirk has been with Microsoft for 8 years in various groups including Hardware, eHome and five years in the SQL Server group developing Integration Services. Kirk is primarily responsible for the design and implementation of the Integration Services runtime. Before Microsoft, Kirk worked for various small to midsized software companies writing educational, dental, and online software.

Sommaire

Getting Started
- 1 Welcome to SQL Server Integration Services 2005
- 2 Setting Up Integration Services
- 3 Migrating from DTS
- 4 Building a Package-Quick Start
Integration Services Basics and Concepts
- 5 The Business Intelligence Development Studio
- 6 The Building Blocks of Integration Services
- 7 Grouping Control Flow with Containers
Control Flow Services
- 8 The Stock Tasks
- 9 Using Expressions
- 10 The Stock Connection Managers
- 11 Logging and the Stock Log Providers
- 12 The Venerable Variable
- 13 Looping and Foreach Enumerators
Management Services
- 14 Configuring and Deploying Solutions
- 15 Using The Script Task
- 16 Using Source Control
- 17 SQL Server Management Studio
- 18 Securing Packages
The Data Flow Task
- 19 Introducing the Data Flow Task
- 20 The Stock Data Flow Components
- 21 Using the Script Component
- 22 Advanced Data Flow Transformations
- 23 Data Flow Task Internals and Tuning
Programming Integration Services
- 24 Building Custom Tasks
- 25 Building Custom Data Flow Components

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Sams
Auteur(s)	Kirk Haselden
Parution	29/09/2006
Nb. de pages	720
Format	18 x 23,5
Couverture	Broché
Poids	1160g
Intérieur	Noir et Blanc
EAN13	9780672327810
ISBN13	978-0-672-32781-0