Data Transformation Services (DTS) remains an important
tool in the arsenal of database administrators and web designers
that need to move data between data repositories. These repositories
can include SQL Server 2000, a variety of other databases
as well as text files, and Excel files. You're also being
compelled to move towards the Visual Studio .NET framework
as you move forward with software development based on the
Microsoft platform. Therefor you will invariably run into
the problems outlined below.
With ten minutes of cleanup you can use a DTS package generated
by SQL Server 2000 within the Visual Studio .NET framework.
You'll have all the benefits of running in the Visual Studio
.NET framework plus be able to programmatically control the
behavior of the DTS package. This article will get you there
quickly while navigating a path that isn't always straight
There are two important reasons why you'll want to do this.