Microsoft SQL server 2000 dts step by step

Carl Rabeler - Collection Step by Step

462 pages, parution le 15/09/2003

Ajouter à une liste

Indisponible

Résumé

Your hands-on, self-study guide to developing applications using SQL Server 2000 Transformation Services Teach yourself the full range of capabilities of SQL Server 2000 Data Transformation Services (DTS)-one step at a time!

This practical, hands-on tutorial expertly guides you through the development of a DTS application that extracts and transforms data from a database into a data warehouse. Work at your own pace through easy-to-follow lessons and hands-on exercises to learn essential techniques for performing basic and advanced tasks and for creating custom tasks. You'll learn how to work with heterogeneous data sources to extract, transform, and consolidate data using ActiveX® scripts. And you'll learn how to incorporate execution logic, flow control, looping, transaction control, logging, error handling, and security into DTS packages. When you complete the step-by-step lessons, you'll have built a full data movement application.

Introduction
Jumping into DTS
Using DTS designer to build and extend packages
Working with DTS packages
Creating advanced DTS tasks
Working with advanced DTS options
Dynamically configuring DTS package objects
Using ActiveX script tasks
Incorporating error handling into DTS packages
Completing the data movement application
Operating the data movement application

Index

L'auteur - Carl Rabeler

Carl Rabeler is an MCT, MCDBA, and MCSE. In conjunction with the Business Intelligence Practices group at Microsoft, Carl authored the technical documentation for the SQL Server Accelerator for Business Intelligence, the DTS Programming Practices Used in SQL Server Accelerator for Business Intelligence white paper, and the Microsoft Analysis Services Performance Guide white paper. Carl also wrote the SQL Server High Availability Series, which is available via MSDN. He also wrote the Microsoft SQL Server 2000 System Administration MCSE Training Kit and the Academic Learning Series course based on that book. Before that, he was a Subject Matter Expert for the Microsoft Official Courseware group from 1995 through 2000, working with both Microsoft SQL Server and Microsoft Exchange Server. Carl has also been an independent software consultant since 1989, developing hardware and software solutions for a variety of customers.

Caractéristiques techniques

	PAPIER
Éditeur(s)	Microsoft Press
Auteur(s)	Carl Rabeler
Collection	Step by Step
Parution	15/09/2003
Nb. de pages	462
Format	18,5 x 22,8
Couverture	Broché
Poids	925g
Intérieur	Noir et Blanc
EAN13	9780735619166
ISBN13	978-0-7356-1916-6