My web application with webbox (w2003 server) / sql server 2K box still
wont allow me to use a DTS. However, it does work on the development
box (w2000 server or wXP) which has sql server installed. I've reviewed
the sites below.

I've registered all the dlls per the website
(http://www.sqldts.com/default.aspx?225), and the sqlunirl.dll exists
in the c:\windows\system directory (also copied to
c:\windows\system32). I also reviewed the redist.txt file on the sql
server 2K install disk.

The error I get is below:

The specified module could not be found.
Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.

Exception Details: System.IO.FileNotFoundException: The specified
module could not be found.

[FileNotFoundException: The specified module could not be found.]
CNN.WebForm1.CallDTS() in
C:\Inetpub\wwwroot\CNN\cnnImport.aspx.vb:362

It does not specify which 'module' that it can't find, but it's failing
on the line of code: oPKG = New DTS.Package

I tried copying the dll files to 'c:\program files\Microsoft SQL
Server' and the rll files to 'c:\program files\Microsoft SQL
Server\Resources\1033\', to 'c:\program files\microsoft sql
server\80\Tools\Binn', to the 'c:\' root, and to the bin folder of the
web directory. And because the wwwroot folder is on a different drive,
I tried creating a program files\microsoft sql server in that drive,
with the dlls / rlls in it.

I also tried the solution below, but just got the error message that a
dependency of dtsPKG80.dll could not be found.

http://sqldev.net/dts/DotNETCookBook.htm

Anyone have any ideas?