p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   SQL Server 2000 (http://p2p.wrox.com/forumdisplay.php?f=20)
-   -   CDONTS and ActiveX in a DTS Package (http://p2p.wrox.com/showthread.php?t=29472)

Hal Levy May 18th, 2005 01:25 PM

CDONTS and ActiveX in a DTS Package
I am creating a DTS Package to run on a schedule.
The DTS Package should send an email.

1. I Select the content into a DTSGlobalVariable (Variant) in an Execute SQL Task
2. On success I go to an ActiveX script task that takes the data out of the global and sends and email...

All runs fine when the objMail.Send is removed from the script... When the .Send is there, I get an error "ActiveX Scripting encountered a Run Time Error durring the execution of the script."

Clearly this takes place when CDONTS tries to send the email-- I have never had to set up a server to use CDONTS- it was always already done... Is there some setting for the target server?

Hal Levy
I am here to help you, not do it for you.
That is, unless you hire me. I am looking for work.

All times are GMT -4. The time now is 04:42 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.