looking for a way to send HTML formatted emails from a DTS package

Posted on 2005-04-21
Last Modified: 2010-03-19
I have DTS package that properly creates an output string that looks like:


I am attempting to send an email using the DTS Send Mail Task, in which I want to display the information in table form.  What I get is just the text noted above.  What am I missing?  This is the last piece of the puzzle and I'm going nuts.

Any help would be greatly appreciated.  I know that for this is probably a cake walk for most of you, but since I have no hair left, I am going to assign a high point value just to get it over with.

Thanks in advance for you help.

Question by:KenMSchwartz
    LVL 28

    Expert Comment

    For an email to be displayed like an HTML page, you have to set the content-type to "text/html".  Unfortunately, in DTS Send Mail Task, there is no option for you to be able to change this property.  An alternative is for you to create an html file and attach that in your email.

    Author Comment


    Thanks for that suggestion.  I thought about that as well, but the client would like to see it in the body of the email.  Any other suggestions.
    LVL 6

    Accepted Solution

    As a workaround to the unability of DTS Send Mail task to send HTML e-mails, you may want to consider using CDOSYS through stored procedure in SQL Server. There is a sp_ that allows you to send HTML formated e-mails deom within your SQL Server - you can call it from your DTS using Execute SQL task.
    The description of how to use CDOSYS in SQL and code for the sp_ is here:;en-us;312839


    Author Comment


    Outstanding solution.  Thanks

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
    Via a live example, show how to shrink a transaction log file down to a reasonable size.

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    25 Experts available now in Live!

    Get 1:1 Help Now