Redistributing DTS with your program

In one of our program, to convert the legacy data into our SQL Server, we used the function of DTS.  But now our customer tell us that they want to install the program on a computer without SQL Server.  What shall I do now?  Revise the code or try to find a way to distribute the DTS component with our program?  Anyway, I have to solve this problem as soon as possible.

Finally, I find some useful information in the redist.txt file that is on the root of our SQL Server CD-ROM.  It lists all the files used in the DTS service. There are two sections about DTS, the first lists all of the files required, the second details which files must be registered and one or two that must placed in the Windows system directory.

As well as the usual dynamic-link libraries (DLLs) there are also some localized resource files (RLLs) listed. Resource files should be placed in a sub-directory structure under the DLLs, /Resources/XXXX/, where XXXX represents the language of the SQL Server instance. 1033 is the language identifier for "English, US", so assuming the DLLs are in the ApplicationDirectory, the RLLs would be in C:/Program Files/ApplicationDirectory/Resources/1033/

The following table summarises the files, their locations and any registration requirements:

Filename	Description	Installation Folder	Register
sqlresld.dll	Satellite Resource DLL Loader	/ApplicationDirectory/
dtsffile.dll	DTS Flat File OLE DB Provider	/ApplicationDirectory/	Yes
dtsffile.rll	DTS Resource File	/ApplicationDirectory/Resources/1033/
dtspkg.dll	DTS Package	/ApplicationDirectory/	Yes
dtspkg.rll	DTS Resource File	/ApplicationDirectory/Resources/1033/
dtspump.dll	DTS Datapump	/ApplicationDirectory/	Yes
dtspump.rll	DTS Resource File	/ApplicationDirectory/Resources/1033/
axscphst.dll	DTS ActiveX Script Host	/ApplicationDirectory/	Yes
axscphst.rll	DTS Resource File	/ApplicationDirectory/Resources/1033/
dtsrun.exe	DTSRun Command Line Utility to Execute a DTS Package	/ApplicationDirectory/
dtsrun.rll	DTS Resource File	/ApplicationDirectory/Resources/1033/
SQL Server 7.0 Only
sqlwoa.dll	SQL Server Unicode / ANSI Translation Layer	C:/Winnt/System32 Or C:/Windows/System
sqlwid.dll	SQL Server Unicode / ANSI Translation Layer	C:/Winnt/System32 Or C:/Windows/System
SQL Server 2000 Only
custtask.dll	DTS Custom Tasks File	/ApplicationDirectory/	Yes
custtask.rll	DTS Custom Tasks Resource File	/ApplicationDirectory/Resources/1033/
sqlunirl.dll	SQL Server Unicode / ANSI Translation Layer	C:/Winnt/System32 Or C:/Windows/System

Based on my tests, I'm sure that the DTS can be installed on Microsoft Windows NT 4.0, Windows 2000, Windows Me, and Windows 98.