Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Sending the mail from SSIS

Author  Topic 

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2009-11-26 : 04:02:52
Dear All,
I am beginner to SSIS can somebody help me to how to send the maul from SSIS.

I just drag and drop the "Send mail task" from the tool box and tried to configure the SMTP bu putting my SMTP server name and "Use windows authentication" enabled.

When i execute the task it throwing an error

[Send Mail Task] Error: An error occurred with the following error message: "The SMTP server requires a secure connection or the client was not authenticated. The server response was: authentication required - for help go to http://help.yahoo.com/help/us/mail/pop/pop-11.html".

If somebody is having any idea on this please help me out.

Thanks in advance,
Gangadhar


rajdaksha
Aged Yak Warrior

595 Posts

Posted - 2009-11-26 : 04:25:47
Hi

May be its useful

http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/

http://www.databasejournal.com/features/mssql/article.php/3646986/SQL-Server-2005-Integration-Services---Part-39---Send-Mail-Task.htm


-------------------------
R...
Go to Top of Page

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2009-11-26 : 10:57:31
I am able to send the mail from SQL but i want to know how to send the mail from SSIS.Please help..
When i run the package with Send mail task i am getting this error:

[Send Mail Task] Error: An error occurred with the following error message: "The SMTP server requires a secure connection or the client was not authenticated. The server response was: authentication required - for help go to http://help.yahoo.com/help/us/mail/pop/pop-11.html".
Go to Top of Page
   

- Advertisement -