Thursday, March 22, 2012

Error: -2147024770 when i scheduled a package containing a custom task

I create a VB ActiveX DLL custom task, when i execute the package containing
the DLL custom task, all is ok.
But when i scheduled the package i receive the message "Error: -2147024770
The specified module could not be found".
In the code of the VB custom task i use the sysdtssteplog table from MSDB an
d it doesn't log anything.
What's the problem?
Thanks!Jay,
When you run it, what context (login, machine, etc) are you running under?
When you schedule it (I assume through SQL Agent), what context (login,
machine, etc) are you running under?
I suspect that the SQL Server account (either the account running the SQL
Server service or the SQL Agent proxy account) does not have rights to the
location where the DLL is stored. Make sure that the DLL can be reached by
the SQL Server.
Russell Fields
"JayF" <anonymous@.discussions.microsoft.com> wrote in message
news:025B1AE0-EDC9-482C-B93E-788775D19D24@.microsoft.com...
quote:

> I create a VB ActiveX DLL custom task, when i execute the package

containing the DLL custom task, all is ok.
quote:

> But when i scheduled the package i receive the message

Error: -2147024770 The specified module could not be found".
quote:

> In the code of the VB custom task i use the sysdtssteplog table from MSDB

and it doesn't log anything.
quote:

> What's the problem?
> Thanks!
sql

No comments:

Post a Comment