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.
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.
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.