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 and it doesn't log anything
What's the problem
Thanks!Whenever I seen that error from VB - SQL it has always
been in the context that the SQL command run from VB has
not worked.
Try a trace to see exactly what SQL was processed.
J
>--Original Message--
>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 and 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...
> 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
and it doesn't log anything.
> What's the problem?
> Thanks!

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

Error with Email Subscriptions

Hi,
I have configured the Email settings, and have set up a scheduled
subscription to send report links.
The SQL Server Agent is running and I have also configured SQL Mail with
the correct MAPI Profile.
The subscriptions dont work and give the following error "The e-mail address
of one or more recipients is not valid.".
The email Ids are valid.
Can anybody pls help?
Thanks & Regards
MPPWell i had the same problem.It occurs when the email is not in the domain of
the server.I still don't know what 2 do.
"MPP" wrote:
> Hi,
> I have configured the Email settings, and have set up a scheduled
> subscription to send report links.
> The SQL Server Agent is running and I have also configured SQL Mail with
> the correct MAPI Profile.
> The subscriptions dont work and give the following error "The e-mail address
> of one or more recipients is not valid.".
> The email Ids are valid.
> Can anybody pls help?
> Thanks & Regards
> MPP
>
>|||You have to set your mail server up to allow relaying
--
---
Yes, I searched first :)
"MPP" wrote:
> Hi,
> I have configured the Email settings, and have set up a scheduled
> subscription to send report links.
> The SQL Server Agent is running and I have also configured SQL Mail with
> the correct MAPI Profile.
> The subscriptions dont work and give the following error "The e-mail address
> of one or more recipients is not valid.".
> The email Ids are valid.
> Can anybody pls help?
> Thanks & Regards
> MPP
>
>