send mail task error

Hot Topic

Running 2000 and 2005 Reporting services on a single server
SQL Impesonate Logon Problem
Return more than 4000 characters from CLR stored procedure
VS2005 & BI Calculations Tab
Package Migration Wizard error -- Index was out of range
Strange performance problem or bug in SQL 2005.
Basing Report on a Procedure with Cursor
C# and SQL 2005
How to format a text box to show bullets
date field select help

SQL Server

Backup & Restore encryption key
MySql and Sql question
sql statement from webform with dynamic join, how?
Subscription to more than one report
ANSI PADDING OFF not working
Inserting custom data
Empty Messagebox
How to insert only new records (not already in destination)
SQL 2005 64bit
Getting error in SQL Server Destination

send mail task error

Hi All,

I am trying to use Send Mail Task to send mails within my package and I get the following error. "The server response was: 5.7.1 Unable to relay for test@mail.com". Can anyone help me on this

Thanks

Answer this question

send mail task error

  • Agarwal

    Thanks for all the help Darren, I dont know If I fully understood what u said but I think what I was looking for.

    Thanks a Lot


  • Dan Wood

    Talk to the person who manages you SMTP server. Simply put mail servers are secured and only accept messages for certain addresses. To relay a mail is to accept the mesage from a client or server and then send it on to the next stage or the final destination (server). Often you only relay for your own domain. If your mail server was an open relay, not secured, then it would accept mail addressed to anyone, and that is what spammers can use to hide their tracks. Over simplified, but really this means the mail server is saying I am not allowed to send mail to that recipient.

  • Chris Allison

    No. The task we have in SSIS uses SMTP and only SMTP. The task we had in DTS, or SQL Mail used MAPI (devil spawn), which meant we had to have a full MAPI (devil spawn) client and mail profile, so realistically we needed full Outlook on the machine. This offered us the choice of using various connectors within the profile, such as SMTP/POP3 or Exchange. In SSIS we have no choice, it only supports SMTP directly and you cannot use a MAPI (devil spawn) profile even if you were mad enough to want to.

    Put another way, Exchange can expose a plain old SMTP server interface as well as the next mail server product, but day to day desktop use means when we use Outlook we talk RPC or RPC over HTTPS to get all the bells and whistles, not SMTP otherwise you might as well use Outlook Express/Thunderbird etc with your free dial-up ISP. For just sending mail from SSIS, Exchange is an overkill, but there is nothing wrong with it either, we just use the simple route in rather than the fancy one.



  • freeskier89

    Thanks Darren for your input, I was able to send the mail using another smtp server, however I have another query which I think you would be able to answer, If I am using an exchange server as my smtp server to send the mail, do I have to install outlook or something else on the server where I eventually would be running my packages

    Thanks
  • send mail task error
Answer this question