ActiveX Script Task/Function Not Found

We have a SQL Server 2005 Cluster that we are trying to send email from to notify when certain jobs have completed, failed, etc. We are having a bit of a problem getting the email to work and I believe that the failure is at the SMTP server, not at the SQL level.

That being said, I'm trying to create a simple SSIS package that I can use to test connectivity to the SMTP server with and send email. I've added an ActiveX Script Task that calls a COM object that actually sends the email. I keep getting a "Function not found." error when I try to execute the package, and I have no idea why I'm getting that. It says that the errors were found during validation.

Can anyone help?

Function not found is most likely the result of an invalid reference.

However, we do not recommend using the ActiveX script task - it is only for backwards compat. Better to move to the Script task which uses VB.Net and which enables a much better development and debugging experience.

Donald

Active/Active in MS Virtual Server 2005

Did anyone implement Active/Active cluster configuration in MS
Virtual Server 2005 env? I successfully completed it for
Active/Passive configuration.
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/Clustering-A...ict255024.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=880389
I have only tried a single instance, but I don't see why I couldn't. What
issues are you having?
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
"giora" <UseLinkToEmail@.dbForumz.com> wrote in message
news:4_880389_2e113e64de181962885b463a2452ae5f@.dbf orumz.com...
> Did anyone implement Active/Active cluster configuration in MS
> Virtual Server 2005 env? I successfully completed it for
> Active/Passive configuration.
> --
> Posted using the http://www.dbforumz.com interface, at author's request
> Articles individually checked for conformance to usenet standards
> Topic URL:
> http://www.dbforumz.com/Clustering-A...ict255024.html
> Visit Topic URL to contact author (reg. req'd). Report abuse:
> http://www.dbforumz.com/eform.php?p=880389
|||I am building one with SQL 2000 as one instance and SQL 2005 as another
instance. I will let you know how it works out.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"giora" <UseLinkToEmail@.dbForumz.com> wrote in message
news:4_880389_2e113e64de181962885b463a2452ae5f@.dbf orumz.com...
> Did anyone implement Active/Active cluster configuration in MS
> Virtual Server 2005 env? I successfully completed it for
> Active/Passive configuration.
> --
> Posted using the http://www.dbforumz.com interface, at author's request
> Articles individually checked for conformance to usenet standards
> Topic URL:
> http://www.dbforumz.com/Clustering-A...ict255024.html
> Visit Topic URL to contact author (reg. req'd). Report abuse:
> http://www.dbforumz.com/eform.php?p=880389
sql