Re: DTS in ASP

#1

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

"Niranjan Ramasamy" <n_ramasamy (AT) hotmail (DOT) com> wrote

Quote:

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

#2

Hi

Regarding the thread I have implemented

Execute a package from Active Server Pages (ASP
(http://www.sqldts.com/default.aspx?207

There is only one remaining problem. Most DTS run fine but one of them has the following error

- DTS runs fine manuall
- DTS stops while running via AS
- Few statements runs fine (like task Dynamic Properties, Execute SQL task, Transform Data task
- After the Transform Data Task I can see the data in a temporary tabl
- The package log also sais that this one was executed fin
- The next job however is not execute
- The log sais nothing about malfunctioning, all remaining tasks are not execute
- The main package (all before is done in a sub package that is called from the main DTS) shows that

Step Error Source: Microsoft Data Transformation Services (DTS) Packag
Step Error Description:Execution was canceled by user
Step Error code: 8004042
Step Error Help File:sqldts80.hl
Step Error Help Context ID:1010

Does anybody know why it was cancelled in ASP

Regards
Edgar

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: DTS in ASP

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: DTS in ASP - 07-01-2003 , 01:32 AM

Re: DTS in ASP - 05-23-2004 , 04:21 AM