I am using SMTP Mail Task on a windows 2003 server and have the SMTP
Virtual Server portion of IIS running with anonymous access enabled. I
have a DTS package which consists of a single SMTPMail task that sends
an email to myself via the server I just mentioned.

When I run this task from an external client (my own machine - windows
xp - non local) it succeeds, and also when I use the "ping" command at
the "server" tab in the properties of this task, it pings successfully.

However, when I login to the 2003 server on which the sql server, iis,
and SMTP virtual reside, open the task, and attempt to run it it fails.
The ping is also unsuccessful. I have tried using "localhost",
127.0.0.1, and any other number of possibilities to no avail.

Lastly I can telnet to my own smtp mail server via port 25 from both my
external client machine (xp) and the locally on the 2003 server.

I also use Windows auth on both machines using (so same user login and
pass, and admin rights on both machines).

Thanks in advance,

Dustin

Here are the results of more tests. When I remote login to the server
(2003) and open Enterprise Manager and open any SMTP mail task I cannot
ping anything or execute the smpt mail task successfully. Even when I
enter an external smpt virtual server address that I know works, the
ping fails, as does the mail portion of the job.

However if I execute a telnet to any of these same SMTP servers from
the same machine, it is successful. It seems to isolate the problem to
how the DTS SMPT Mail Task job is pinging / connecting to the outside
or local smpt machines. I'm thinking maybe its using an outbound port
that something else is using?

Any insight is appreciated.

Thanks,

Dustin


Dustin wrote:

Dustin,

Unfortunetly I don't have an answer for your question. But I will say
that from everyone I've talked to I hear that the smtp mail task is
unreliable. I tend to use an extended stored procedure for automated
emails in my packages: xp_smtp_sendmail

It's very easy to use and I've never had a problem. Just something to
consider.


Jay


Dustin wrote: