SQL Server DTS, Sams
Microsoft .NET Framework, ASP.NET, Visual C# (CSharp, C Sharp, C-Sharp) Developer Training, Visual Studio
|
Contents |
C# Online.NET Book Review
First things first. Why review a book that was published in 2001? Well, the reason is that even though software and books have definitely moved on since then, the fact is that many installations still run older versions of SQL Server. In fact, I have received requests from users for book recommendations for some older software products.
SQL Server Data Transformation Services (DTS) was released by Microsoft with SQL Server 7.0. It includes an easy to use, graphical tool for exporting, importing, and transforming data. It is meant to replace BCP. With the release of SQL Server 2000, DTS became more fully featured, robust, and stable. Developers began using DTS to build a variety of data loading and transformation solutions. In the end, DTS had become a very popular ETL—Extract, Transform and Load—tool. It remains in use in shops around the world.
The book is a useful introduction to SQL Server DTS for either programmers already familiar with SQL Server or for database administrators (DBAs) who program. But, the reader should not expect a detailed, peek-under-the-hood type, technical manual.
There are problems with Chapter 2—confusion over which version of SQL Server is being discussed, even errors—which might take the reader a while to understand. So, if that chapter is merely skimmed by the reader, the remainder of the book is rewarding. For example, there is a lucid description of how to go about creating a custom DTS task using Visual Basic.
All source code examples are in either the VBScript of Visual Basic languages.
Bottom line
SQL Server DTS is a good introduction to programming with DTS.
Publisher's description
Book Overview
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.
Book Description
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.
From the Back Cover:
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.
About the author(s)
Jim Samuelson is the Enterprise Data Services Practice Lead for Magenic Technologies in Minneapolis. Jim has over 11 years of experience in Decision Support and Business Intelligence Systems, and currently serves on the Microsoft Business Intelligence Partner Advisory Council.
Jim speaks at local, regional and national events on various database and software development topics. He holds an MBA in Finance and M.I.S, and is a Microsoft Certified Solution Developer (MCSD).
Marcelino Santos, MCSE, MCSD, is a Senior Consultant at Magnenic Technologies. He has over 16 years of experience as a business analys and software developer within the areas of enterprise modeling, strategic business and information systems planning, data and functional modeling, decision tools, business solutions, and systems integration.
Steve Hughes, Brian Sullivan, Steve Miller
Table of Contents (abbreviated)
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.
