We have two separated machines, one for MS SQL Server and another for web server. The problem is that I wrote an asp file to read DTS task titles on the web server which doesn't have SQL Server installed. However, because of absence of SQL Server, my ASP couldn't use certain components such as Server, DTSGlobalVariables, etc. I was told that I need to find an appropriate DLL file and register them.

Does anybody have any idea which DLL to use and where to register them??

The DTS dlls can be found here.**

Redistributing DTS with your program
(http://www.sqldts.com/default.aspx?225)

** Grab yourself a machine with the relevant version of SQL Server that you
are using. Note where the dlls listed in the article are located on the
filesystem. Recreate the structure. Register the dlls in these locations.
The locations in the articles work but are not best practice.

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Park Hye Yion" <anonymous (AT) discussions (DOT) microsoft.com> wrote

the web server which doesn't have SQL Server installed. However, because of
absence of SQL Server, my ASP couldn't use certain components such as
Server, DTSGlobalVariables, etc. I was told that I need to find an
appropriate DLL file and register them.