Problem running DTS package from asp

#1

Hello

We're developing some new code, trying to run a dts package from an asp web
page.

The package runs fine locally.

However, when trying to execute the package via asp, using this line of code

Set oPkg = Server.CreateObject("DTS.Package")

We get the error

Server object error 'ASP 0177 : 800401f3'

Server.CreateObject Failed

/alerting/mailer.asp, line 11

800401f3

Any ideas?

Thanks for your help.

Richard

#2

In article <ezyfGILoEHA.2588 (AT) TK2MSFTNGP12 (DOT) phx.gbl>, Richard wrote:

Quote:

Hello

We're developing some new code, trying to run a dts package from an asp web
page.

The package runs fine locally.

However, when trying to execute the package via asp, using this line of code

Set oPkg = Server.CreateObject("DTS.Package")

We get the error

Server object error 'ASP 0177 : 800401f3'

Server.CreateObject Failed

/alerting/mailer.asp, line 11

800401f3

Any ideas?

Thanks for your help.

Richard

Do you have the DTS dlls registered on the webserver?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know

#3

The DLLs are registered on the sql server, recently sp3a'd. They're not
registered on the actual web server, and when trying to do so, I get the
error message

LoadLibrary("pathtodll") failed - The specified module could not be found.

Any ideas?

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Quote:

In article <ezyfGILoEHA.2588 (AT) TK2MSFTNGP12 (DOT) phx.gbl>, Richard wrote:
Hello

We're developing some new code, trying to run a dts package from an asp
web
page.

The package runs fine locally.

However, when trying to execute the package via asp, using this line of
code

Set oPkg = Server.CreateObject("DTS.Package")

We get the error

Server object error 'ASP 0177 : 800401f3'

Server.CreateObject Failed

/alerting/mailer.asp, line 11

800401f3

Any ideas?

Thanks for your help.

Richard

Do you have the DTS dlls registered on the webserver?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know

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

Problem running DTS package from asp

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

Problem running DTS package from asp - 09-22-2004 , 09:41 AM

Re: Problem running DTS package from asp - 09-22-2004 , 04:31 PM

Re: Problem running DTS package from asp - 09-23-2004 , 09:40 AM