I am trying to call a DTS package from an ASP page. I didn't want to
go through the permissions nightmare so I created a DLL and installed
it under COM+. I am calling it from an ASP page and getting
the following message:

Package FHLSubs failed

Error in Object Execution
Number: -2147417848
Source: SQLDTS_ExecDTS
Description: Automation error The object invoked has disconnected from
its clients.

Now, I can create a VB EXE using basically the same code and it works
fine. But when I invoke it from the ASP page, I get the
diconnect error.

I've traced through the code and it is getting past the CreateObject
line and Execute statement...but it is then disconnecting. Has anyone
seen this, or gotten this to work? Any help would be
greatly appreciated. Thanks!

CS

In article <87feb722.0311181217.6b34aed (AT) posting (DOT) google.com>, Chad
<chadscc (AT) hotmail (DOT) com> writes
What have you done since your last post?

What is the code that errors? Please indicate the line that errors. What
is the source of the error you give above?



--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org