SQL Server DTS

Steve Hughes, Steve Miller, Jim Samuelson, Marcelino Santos, Brian Sullivan

486 pages, parution le 01/10/2001

Ajouter à une liste

Indisponible

Résumé

This book appeals to both developers and database administrators who are faced with the common situation of having to migrate or integrate data from one location into another. While the first section of the book is designed for the beginner to DTS, it is assumed that the reader has at least basic database and programming experience. The second section is extensive coding, and is best used by someone with intermediate to advanced programming skills. The third section contains a mix of examples that will be useful to all levels of database administrators and programmers. For the readers who have been using DTS this section can be used as a reference section and help with DTS designs and usage. Unlike other resources available, this book covers data transformation in both SQL Server 7 and 2000.

Contents

Data transformation services - the tool

DTS in the ETL world
DTS - an overview
Connections
DTS tasks
More DTS tasks
DTS workflows
Package
Putting it all together - an extyented DTS example

Automating data transformation services

Building a package using visual basic
Interacting with a package using virtual basic

DTS and the business intelligence process

Introduction to data warehousing and analysis services
Building a datawarehouse with DTS and analysis services
DTS and data mining

Using the tool - Case studies

Custom error logging with DTS
Managing distributed databases with DTS and messages queues
Creating a DTS package from a stored procedure
Data lineage

Caractéristiques techniques

	PAPIER
Éditeur(s)	New Riders
Auteur(s)	Steve Hughes, Steve Miller, Jim Samuelson, Marcelino Santos, Brian Sullivan
Parution	01/10/2001
Nb. de pages	486
Format	17,8 x 22,8
Couverture	Broché
Poids	801g
Intérieur	Noir et Blanc
EAN13	9780735711235
ISBN13	978-0-7357-1123-5