Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Tuesday, December 3, 2013 10:20 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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

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.

Thanks,
Suchitra
Post #1519469
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse