Home > Store

SQL Server DTS

Register your product to gain access to bonus material or receive a coupon.

SQL Server DTS

Book

  • Sorry, this book is no longer in print.
Not for Sale

Description

  • Copyright 2002
  • Edition: 1st
  • Book
  • ISBN-10: 0-7357-1123-2
  • ISBN-13: 978-0-7357-1123-5

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.

Downloads

Downloads

Click below for Downloads related to this title:
DTS2000.zip (2837k)

Sample Content

Downloadable Sample Chapter

Click below for Sample Chapter related to this title:
0735711232.pdf

Table of Contents



PLEASE PROVIDE

I. DATA TRANSFORMATION SERVICES—THE TOOL.

1. Introduction to Extraction, Transformation and Loading (ETL) Environment.
2. Introduction to Data Transformations Services.
3. DTS Package and Components.

II. AUTOMATING DATA TRANSFORMATION SERVICES.

4. Building a Package from a Visual Basic Application.
5. Interacting with a Package from a Visual Basic Application.

III. USING THE TOOL—PUTTING IT ALL TOGETHER.

6. Error Logging.
7. Interacting with ActiveX components.
8. Managing Distributed Databases with DTS and MSMQ.
9. Replication and DTS.
10. Packages that control other packages.
11. Custom Tasks.
12. Building and Managing a Data Warehouse with DTS.
13. DTS and Data Mining.
14. Executing a DTS Package from a Stored Procedure.

Updates

Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership