SSIS Send Email Html Body - SQL Server Forums

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 2005 Forums

SSIS and Import/Export (2005)

SSIS Send Email Html Body

Author

Topic

ismailc
Constraint Violating Yak Guru

290 Posts

Posted - 2008-04-04 : 04:40:52

Hi, I need help please.

I want to send an HTML Email

I have an Htm file that i want to use as my email body on Send Mail Task
MessageSourceType: File Connection
MessageSource: Email.htm

It sends the email with the file in the body but not in HTML format
it outputs the HTML tags + data
eg: <span style="font-size:9.0pt;">Period: 2008.04</span>

I used the same file in a DTS package & that works fine.

Please Assist!

Regards

dineshasanka
Yak Posting Veteran

72 Posts

Posted - 2008-04-04 : 06:47:53

http://msdn2.microsoft.com/en-us/library/ms403365.aspx

---------------------
http://dineshasanka.spaces.live.com/

ismailc
Constraint Violating Yak Guru

290 Posts

Posted - 2008-04-04 : 08:31:53

Thank You very much.

Not what i really want to do, as i want to show a file that has been created from SQL in HTML format.

I could do this easily with DTS, it looks a bit of a long way around to show an html message.

Thank You very much

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources