Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Unable to send excel using Send Mail Task in SSIS Expand / Collapse
Posted Tuesday, December 3, 2013 10:20 PM


Group: General Forum Members
Last Login: Wednesday, December 4, 2013 3:35 AM
Points: 13, Visits: 19

I have developed a package whose output is in Excel. I need to mail this excel to some users. i have Microsoft Exchange Server at office. I tried using SendMail Task and got the following error:

[Send Mail Task] Error: An error occurred with the following error message: "Failure sending mail. System.IO.IOException: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. System.Net.Sockets.SocketException: An existing connection was forcibly closed by the remote host".

How to correct this??

Also, i am unable to enable sql server agent in sql server 2008 R2.

Post #1519469
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse