Introduction to importing data through COM+ into SQL Server using DTS

One of the better features of SQL Server (7 and above) is the ability to import data using DTS.
Since DTS is a fully fledged component it can be packaged up in a COM+ wrapper using VB (or VC obviously) to generate an import tool for your web based system.

There are some limitations to packaging the component which will be discussed later but this series of pages will give some guidelines on how to develop a DTS package for implementation in a COM+ component.

The best source for reference on DTS and COM+ is MSDN coupled with SQL Server Books On Line (SQLBOL)
A basic understanding of COM+ is assumed as is familiarity with creating a DTS package on the server.

The first step is to create the initial DTS Package on the server

Alternatively Contact us for a quote


Home ] Up ] DTS Package ] Creating the COM Component and added the DTS Package ]

Send mail to Webmaster with questions or comments about this web site.
Copyright©1999 SVEK Computing Ltd
Last modified: January 27, 2003