Using a DTS to send SMTP mail to addresses in a table

Posted on 2006-05-31
Last Modified: 2011-09-20

Please could someone kindly provide me with some advice on the best way to achieve the following...

1 - I need to send the same email to a large number of recipients (several thousand) whose addresses reside in a table
2 - I do NOT have access to SQLSendMail so intend to cycle through a recordset using a DTS script and send via SMTP
3 - I believe that sending mails individually is probably not too efficient so considering adding to a recipient list
4 - If writing a script to add all (comma/semi-colon delimited), I believe it will exceed the maximum number of recipients
5 - If adding them to batches, what would be a suitable number and what is the most efficient code to do this?
6 - Is there anyway of creating an SMTP grouping or distribution list on the fly perhaps or is number 5 better?

If you have any example code to share, I would be very grateful indeed!

Many thanks,
Question by:antdow
    LVL 75

    Accepted Solution

    See this link here:

    XPSMTP.DLL - SQL Server SMTP Mail XP
    LVL 13

    Assisted Solution

    I've been doing it like this for years...

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
    Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

    728 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

    15 Experts available now in Live!

    Get 1:1 Help Now