Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Write an Html Message File in SMTP Task

Author  Topic 

ismailc
Constraint Violating Yak Guru

290 Posts

Posted - 2008-03-06 : 05:45:06
Hi, I need help Please (DTS 2000)

I have a package where i send mail with an attachment.
Now that is fine, I use SMTP Mail task with the HTML message but the problem is the users would like know a few detils & value on the text of the email in html.

I can't retrieve a value & insert it in the html.
So what i done is create a message txt file added by the message file option in SMTP, I now can see values but no nice format.

I use SQL to write to the file is there a way to format the font in SQL or some other way to send a html message file that can pass as variables.

Please Any Ideas.

Regards
   

- Advertisement -