SQL DTS Resources for SQL Server
Introduction
As I work with a particular topic or problem, I often research on the Internet
different opinions, white papers, etc. Here is a list of resources that are located both
on SQL Server Central and other sites that I have found useful.
Online Resources - General
| Data Transformation Services (DTS) in
Microsoft SQL Server 2000 |
An overview white paper from MS on DTS. |
| Distributing SQL Server Client Components | Distributing the SQL server client components. Includes based information about sqlredis.exe hich will install the connectivity. The detailed switches for sqlredis.exe are here. Also an explanation on deploying solutions. |
| DTS Object Model Diagram | Starting point for the object models for DTS. |
| DTS FAQ | From sqldts.com, a good place to look for general information |
| SQL Server Central DTS Articles | The list of all articles on this site relating to DTS. |
| Building a DTS Custom Task | Starting point on msdn for samples for building custom tasks. |
| Extended DTS Objects | A look at the new DTS objects in SQL 2000 as applied to SQL 7. |
Online Resources - VB
| Creating DTS Packages in Visual Basic |
Online Resources - C++
| Implementing and Testing a DTS Custom Transformation | A desccription of how to implement a custom task using Visual C++. |
Bugs
Books
| RECOMMENDED |  Professional SQL Server 2000 DTS |
I know I'm slightly biased, but this is a good beginning book for DTS development. It covers a number of topics and is worth owning. |
| RECOMMENDED |
|
Haven't read it, but glanced through it and have had some people tell me it's worth buying. |
Conclusions
There are lots more bugs and I will keep adding them. If you have some, please let me know. As always, I welcome feedback for this article (use the 'Your Opinion' tab below) and please take
the time to rate this article.
Steve Jones
©dkRanch.net April 2002