PROFESSIONAL SQL SERVER 2000 DTS
Ouvrage 0-7645-4368-7 : PROFESSIONAL SQL SERVER 2000 DTS
One of the new outstanding features of SQL Server
is Data Transformation Services (DTS). DTS can be
used by both developers and database administrators
(DBAs) and is attracting a lot of interest. There is a
demand for information and currently no other books
are available to satisfy this. DTS enables data to be
moved between a wide variety of sources and
destinations, as well as transforming the data along the way
to suit your requirements. DTS can be used to
maximum effect in data-driven applications, enabling
dynamic data transfer across internet and intranet
applications. This offers rapid and effective solutions to
common problems such as:
Automatically transferring data into data
warehouses
Importing and exporting data to and from other
applications for analysis and reporting
Moving working copies of databases between
servers
The capabilities of DTS are large and this book
will give the reader a complete picture of how to use DTS to
its fullest potential.
Data Transformation Services (DTS) helps you create
a transactional system to load and transform your
data from, and to a wide variety of sources. SQL
Server DTS was introduced in the release of SQL Server
7.0, however, SQL Server 2000 sees the
functionality and power of this outstanding and incredibly useful
tool greatly increased. DTS can be used to maximum
effect in data-driven applications, offering rapid and
effective solutions to a wide range of common
problems.
Professional SQL Server DTS provides a complete
introduction to DTS fundamentals and architecture
before exploring the more complex data
transformations involved in moving data between different servers,
applications, and providers. The book then focuses
on DTS programming via the DTS object model,
enabling developers to incorporate custom
transformations and reporting capabilities into their applications.
Advanced topics are explained including error
handling, dynamic data loading, and data warehouses. With
code and case studies this book gives the reader a
complete picture of how to use DTS to its fullest
potential.
Who is this book for?
This book is principally aimed at database
programmers and administrators who have a working knowledge
of SQL Server, and who wish to take DTS beyond its
most basic level and tailor it to their needs. It will also
appeal to managers and project managers who want to
gain an understanding of DTS and how it could
benefit their businesses.
What does this book cover?
A detailed explanation of the seventeen
principal DTS tasks
Connecting to, querying, and converting
heterogeneous data
Dynamic configuration of your DTS packages
Enhancing your DTS packages with VBScript and
Visual Basic
Writing your own custom tasks
Using DTS in a data-warehousing environment
Employing DTS in other applications
Brian Knight currently writes for SQL Magazine and
also has a weekly column at the database website
Swynk (swynk.com), where he co-runs the SQL Server
area. He also works as a Sr. SQL Server DBA and
spends most of his time deep in DTS and SQL Server.
Todd Robinson (MCP, MCP+I, MCP+SB, MCSE, MCSE+I,
MCSD, MCDBA, MCT, CCNA) lives in
Atlanta, GA where he is an internet application
developer and data warehousing guru for Metlife. He
specializes in MTS/COM+, ASP, XML, SQL Server and
related Windows DNA technologies. In addition to
his normal job duties at Metlife, he is President
of GradesNow.com an internet application service for
teachers, students and parents to allow access to
grades online.
Mark Chaffin is Data Warehouse Architect for Encore
Development (encoredev.com) and has developed
numerous decision support systems for clients in
such industries as technology, mortgage banking, retail,
sports statistics, financial services and
insurance. He also has experience in clickstream analytics, data
mining, transactional application architecture,
Internet application architecture, database administration and
database design.
Table of Contents
Chapter 1: Welcome to DTS
Chapter 2: DTS Fundamentals
Chapter 3: Advanced Tasks
Chapter 4: Advanced Settings in DTS
Chapter 5: Querying Heterogeneous Data
Chapter 6: Converting Heterogeneous Data
Chapter 7: ActiveX Script Task Fundamentals
Chapter 8: Dynamic Configuration of Package Objects
Chapter 9: Advanced ActiveX Scripting
Chapter 10: Security and DTS
Chapter 11: Error Handling
Chapter 12: Writing Your Own Custom Tasks
Chapter 13: Data Warehouse Loading
Chapter 14: Using DTS from Other Applications
Chapter 15: Warehouse Data Load
Auteur : CHAFFIN
Editeur : HUNGRY MINDS
Nombre de pages : 854
Date de publication : 01 2001
Toute la sélection
Toutes les sélections
Toute la sélection
Site réalisé en partenariat avec Courbis
(Courbis - alternate link), acteur de l'Internet depuis 1988...
Le Monde En Tique