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!
    Regards
    Ismailc, Apr 4, 2008
    #2

  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.
    dineshasanka, Apr 4, 2008
    #3

  3. dineshasanka Moderator

    dineshasanka, Apr 4, 2008
    #4

  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
    Ismailc, Apr 4, 2008
    #5

  5. dineshasanka Moderator

    Sorry for the misunderstaning.
    Have you tried this with databasemail
    dineshasanka, Apr 4, 2008
    #6

Share This Page