SQL Server Performance

SSIS Send Email Html Body

Discussion in 'SQL Server 2005 Integration Services' started by Ismailc, Apr 4, 2008.

  1. Ismailc New Member

    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!
  2. dineshasanka Moderator

    you cannot do this by using exisitng mail task. Instead you can use script task and write some .net code to send mail.
  3. dineshasanka Moderator

  4. Ismailc New Member

    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
  5. dineshasanka Moderator

    Sorry for the misunderstaning.
    Have you tried this with databasemail

Share This Page