Hello all,

How can I determine what context a DTS package runs under
when executed from a dll? I am attempting to execute a
DTS package from a asp script. The COM+ component has
the proper privileges, but the job is failing when
executed from the web. When I run the job manually in
DTS, the job complete successfully.

The error I receive is:

DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1

DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1

DTSRun OnStart: DTSStep_DTSDataPumpTask_6

DTSRun OnError: DTSStep_DTSDataPumpTask_6, Error = -
2147467259 (80004005)

Error string: [Timberline][Timberline ODBC Driver]
[File Library]Timberline ODBC Driver not activated.

Error source: Microsoft OLE DB Provider for ODBC
Drivers

Help file:

Help context: 0

Hi David,

I have found some articles related to this issue, it seems to be IIS and
ASP security issue.

In the following article. If Allow Anonymous is checked, IIS will always
attempt to access the requested resource by impersonating the Anonymous
Logon account (by default, IUSR_machinename).
http://msdn.microsoft.com/library/de...us/dnauth/html
/dnauth_security.asp

306518 INFO: Troubleshooting Guide for 80004005 Errors in Active Server
Pages
http://support.microsoft.com/?id=306518

175671 PRB: 80004005 ConnectionOpen (CreateFile()) Error Accessing SQL
http://support.microsoft.com/?id=175671

290398 PRB: Access Denied When You Try to Start DCOM Server
http://support.microsoft.com/?id=290398

Sincerely,

William Wang
Microsoft Partner Online Support

Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
================================================== ===

This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------

Hi David,

Hope the following article will help:
INF: Execute a SQL Server DTS Package from Active Server Pages
http://support.microsoft.com/default...b;EN-US;252987

You may try to set an error file in DTS package. Then you should see the
detailed error message when the DTS fails.

Open the properties of the DTS package, and then click the General tab:
You will see "Error file". Use this option to specify the file to which
package run-time errors are logged. Click the ellipsis button (...) to
locate and to specify the log file.

Sincerely,

William Wang
Microsoft Partner Online Support

Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
================================================== ===

This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------