DTS in ASP -- sql server dts

Niranjan Ramasamy
6/30/2003 3:46:31 PM

Hi,

I have written an COM object with the DTS components to upload the contents
of Excel file to the SQL Server Database table. The environment is Windows
NT (Web Server) - SQL Server 2000 (Database). The SQL Server 2000 Client
tools are installed in the Windows NT Web Server box. (So the DTS components
are registered). This works. I can upload from excel to SQL Server and
from SQL Server to Excel.

But when I migrate this COM object to other boxes (Customer's Web Server),
it fails. When I checked the environment at the customer site, they have
installed SQL Server 7 Client tools installed in the webserver.

What else do I need to change so that the COM object which works in the
development environment works in the Production environment also?

Thanks.

Niranjan

Allan Mitchell
7/1/2003 7:32:24 AM

Here are a couple of articles to get you started

Execute a package from Active Server Pages (ASP)
http://www.sqldts.com/default.aspx?6,104,207,7,1

Redistributing DTS with your program
http://www.sqldts.com/default.aspx?6,105,225,0,1

You also do not tell us what any errors are. Without them we can only guess
the problem.

--

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

[quoted text, click to view]

sql server dts : DTS in ASP