SMTP Mail Task
version: 1.2.0.0
last updated: 5 August 2005
platform: MSDE 2000 and SQL Server 2000 running Windows 2000 and higher
Content:
Description:
The SMTP Mail Task provides a MAPI free alternative to the existing DTS Send Mail Task; it provides equivalent functionality without having to rely on MAPI or the requirement to have Microsoft Outlook installed. The SMTP Mail Task provides a SMTP based SQL Mail solution for sending MIME based email over SMTP, implemented as a DTS Custom Task. It does not require any software to be installed, just a SMTP email server that can handle the outgoing mail requests. The SMTP Mail Task is using TCP/IP sockets to communicate to port 25.
This is how a possible DTS package might look inside the DTS designer when using the SMTP Mail Task.
Installing:
In order to install the SMTP Custom Task, simply run the installer file: SMTPTask-v1.2.0.0.exe
Uninstalling:
When the task is already installed you can remove the task using Control Panel Add/Remove Programs or simply invoke the installer again and you will get the following option:
Using the SMTP Mail Task:
After the installation is complete the 
SMTP Task icon is added to the DTS Designer Tasks panel
The property pages of the SMTP Custom Task look like this. There are four tabs, General, Message, Server for the SMTP related options, and About for displaying the version and other task specific information.
The General property page contains all the addressing options of the SMTP mail message.
Description of the options:
| General | |
| Description: | This is just informational text to help you describe and identify the custom task and has not meaning during execution of the task |
| From: | Email address of the sender (MANDATORY) |
| From name: | Display name of the sender (OPTIONAL, defaults value is empty) |
| Reply to: | Reply to email address ((OPTIONAL, defaults to FROM value) |
| Return path: | The return path is intended to contain definitive information about the address and route back to the message's originator (OPTIONAL, default value is empty) |
| TO: | Recipients, separated by semicolons. When you need to add display names, the format is Joe Mailman <MyEmail@MyDomain.com> (MANDATORY) |
| CC: | CC recipients, separated by semicolons, when you need to add display names, the format is Pete Recipient <MyFriend@HisDomain.com>;Pete Recipient 2 <MyFriend2@HisDomain.com> (OPTIONAL, default value is empty) |
| BCC: | BCC recipients, separated by semicolons. See CC: on how to use display names for recipients (OPTIONAL, default value is empty) |
The Message property page contains the message subject, type, content and other message options.
Description of the options:
| Message | |
| Subject: | (OPTIONAL, defaults to empty subject line) |
| Message type: | (OPTIONAL, defaults to text/plain message type) |
| Message: | (OPTIONAL, defaults to empty message text) |
| Message file: | (OPTIONAL, no default value) |
| Attachments: | (OPTIONAL, no default value) |
| Priority: | (OPTIONAL, defaults to normal) |
| Delivery receipt: | (OPTIONAL, defaults to false) |
| Read receipt: | (OPTIONAL, defaults to false) |
| Send (button) |
The Server property pages contains the settings related to the SMTP mail server that is used
Description of the options:
| Server | |
| Server: | (MANDATORY) |
| Port: | (MANDATORY, defaults to port 25) |
| Backup server: | (OPTIONAL, default value is empty) |
| Port: | (OPTIONAL, default value is 25, value is only used when a backup server is specified) |
| Timeout: | (MANDATORY, default value is 10.000 milliseconds, 10 seconds) |
| Retry count: | Number of times retrying to connect, 0 will not retry. When a backup server is defined the retry count is repeated for the backup server |
| Authenticate: | |
| User: | |
| Password: | |
| Dump message file: | |
| Ping (button) |
The About tab shows information about the DTS custom task like version, file location and website locations for more information
Description of the options:
| About | |
| Name: | Name of the custom task, in this case this will always say: "SMTP Mail Task" (fixed) |
| Description: | |
| File name: | This contains the exact location where the DLL containing the custom task is loaded from |
| Company name: | |
| Company URL: | |
| Copyright: | |
| File version: | |
| Product version: | |
| Product URL: | |
| Class ID: | |
| Prog ID: | |
| Check for Updates (button) |
Known limitations:
- If you have/had the beta version installed, you will need to uninstall and reinstall the custom task
- If you have packages that use the beta version, you need to redefine the steps that use the SMTP Mail Task, because the on-disk storage format is different between the beta and the release version. The beta task exposed the password property via disconnected edit and the programming model, the fix for this resulted in a on-disk change which does not allow beta packages to be updated in-place.
FAQ:
Q: Can I uninstall the task via the command line?
A: Yes, using MSIEXE.EXE, to uninstall run: MSIEXE.EXE /X {42538BE3-E1EB-42D4-B53B-30-30D1FCD0D8AE}
Q:...
A:...
Troubleshooting:
- ...
Change log:
version 1.1.0
- Fixed password persistence problems of v1.0.0.0
version 1.2.0
- Reduced installer size (download size) from 3.6Mb to 188Kb
- Fixed Windows 2000 problem: "Procedure entry point GetAddrInfoW could not be located in the dynamic link library WS2_32.dll"
- Fixed message edit box, multi line problems
License
SMTP Mail Task - Copyright © SQLDev.Net 1991-2005 (http://SQLDev.Net)
All rights reserved.
Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met:
Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer.
Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution.
Neither the name of SQLDev.Net nor the names of its contributors may be used to endorse or promote products derived from this software without specific prior written permission.
Binaries, source code and any other parts of this distribution may not be incorporated into any software licensed under the terms of the GNU General Public License (GPL) or the GNU Lesser Public License (LGPL). Binaries, source code and any other parts of this distribution
may not be incorporated into any software licensed under any license requiring source code disclosure of derivative works.Modified redistributions of source code, binaries and/or documentation must carry the above copyright as required by clauses (1) and (2) and may retain the name "SQLDev.Net" in source code, documentation and metadata.
The name "SQLDev.Net" is a trademark of SQLDev.Net B.V. the Netherlands.
THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
###