SSIS Send Email Html Body

  • 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:

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

    Please Assist!

    Regards

  • If it absolutely has to be HTML then use a script component and the System.Web.Mail class which provides the properties and methods for setting the format and encoding options.

    Alternatively include your html file as an attachment instead?

    Kindest Regards,

    Frank Bazan

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

    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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply