DTS with ASP

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: E. Davids (anonymous_at_discussions.microsoft.com)
Date: 05/25/04 

Date: Tue, 25 May 2004 08:21:05 -0700

Hi,

Regarding the following link I have implemented:

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

There is only one thing that I can't resolve. Most DTS run fine with ASP but one of them has the following error:

- the particular DTS runs fine manually
- DTS stops while running via ASP
- Few statements runs fine (like task Dynamic Properties, Execute SQL task, Transform Data task)
- After the Transform Data Task I can see the data is in the temporary table
- The package log also sais that this one was executed fine
- The next job however is not executed
- The log sais nothing about malfunctioning, all remaining tasks are not executed anymore
- 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) Package
Step Error Description:Execution was canceled by user.
Step Error code: 80040427
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:10100

Does anybody know why it was cancelled in ASP? Why doesn't the DTS continue with the other 'normal' steps?

Regards,
Edgar

Relevant Pages

  • Not all steps in DTS package execute
    ... When run through DTS Designer, all steps execute except the last one (Step ... DTSRun OnFinish: DTSStep_DTSActiveScriptTask_2 ... Microsoft Data Transformation Services Package ...
    (microsoft.public.sqlserver.dts)
  • Re: Import and Schedule DTS on MSDE
    ... The dtsrun utility executes a package created using Data Transformation Services. ... Displays the command prompt options. ... Displays the encrypted command used to execute the DTS package without executing it. ...
    (microsoft.public.sqlserver.tools)
  • Re: DTS in ASP
    ... Most DTS run fine but one of them has the following error: ... Few statements runs fine (like task Dynamic Properties, Execute SQL task, Transform Data task) ... The package log also sais that this one was executed fine ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS and ASP
    ... The components I refer to are the DTS components. ... which must be installed on the machine running the package. ... COM DLL from ASP if not installed on the web server, no, so neither can you ...
    (microsoft.public.sqlserver.dts)
  • Re: Security
    ... When you execute the DTS by clicking on the package it is running under ... permissions that defined on your workstation (local account probably), ... > I have a dts package that transfers data from one sql server to another. ...
    (microsoft.public.sqlserver.server)