Set SendMail Properties from ActiveX Script

#1

I want to set the properties of my SendMailTask based on the results of
a script that runs and processes a text file out into a table. I can't
seem to find any code that shows me how to set properties for an
existing SendMailTask using VBScript.

I'm setting the text file source name using script but I can't seem to
find the syntax to let me set the properties for the SendMailTask that I
have at the end of the job.

TIA,

Matt Childs
Sr. Systems Analyst
GCI

#2

The following site may help

http://www.sqldts.com/default.aspx?235

Ed

"Matt Childs" wrote:

Quote:

I want to set the properties of my SendMailTask based on the results of
a script that runs and processes a text file out into a table. I can't
seem to find any code that shows me how to set properties for an
existing SendMailTask using VBScript.

I'm setting the text file source name using script but I can't seem to
find the syntax to let me set the properties for the SendMailTask that I
have at the end of the job.

TIA,

Matt Childs
Sr. Systems Analyst
GCI

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

Set SendMail Properties from ActiveX Script

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

Set SendMail Properties from ActiveX Script - 02-02-2005 , 05:25 PM

RE: Set SendMail Properties from ActiveX Script - 02-02-2005 , 08:39 PM