Hello I am trying to set up send mail task using ssis. I am getting the follow error [Send Mail Task] Error: The Simple Mail Transfer Protocol (SMTP) server is not specified. Provide a valid name or IP address of the SMTP server. [Send Mail Task] Error: No recipient is specified. [Send Mail Task] Error: An error occurred with the following error message: "Failure sending mail. System.Net.WebException: Unable to connect to the remote server System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it 172.17.18.87:25".

Please provide the exact settings you've placed in your SMTP Connection Manager and Send Mail Task. If you've used Configurations or Property Expressions, please describe those. Talk to me now on

Hello Todd, This is how i am performing my task. Set Up an SMTP Connection Manager with name smtp01.frank.com I declared a package variable with name SMTPserver and value is smtp01.frank.com In the SMTP Connection manager Properties-->Expressions---->Property i set the property to SMTPServer and declare the Expression as @[User::SMTPserver] Set the Delay Validation to True. Send Mail Task: I declared another package variable with name MessageSource. smtp connection: SMTP Connection Manager. MessageSourceType: Variable MessageSource: User::MessageSource --------> I havent did any changes in properties of the Send Mail task. I am getting these errors every time. [Send Mail Task] Error: No recipient is specified. [Send Mail Task] Error: The Simple Mail Transfer Protocol (SMTP) server is not specified. Provide a valid name or IP address of the SMTP server. Error: The connection "smtp01.frank.com" is not found. This error is thrown by Connections collection when the specific connection element is not found.

OK - I think that the error message about not finding the connection is a red herring, because it's occurring after the first error about not having a recipient. When you set up your Send Mail Task, you need to specify a "to" email address, and you haven't done that. It may be that your SMTP server rejects the connection request if there's no recipient, adding that less-than-helpful message. Talk to me now on

Hello Todd, I have given the from address and to address and i am getting this error again. [Send Mail Task] Error: The Simple Mail Transfer Protocol (SMTP) server is not specified. Provide a valid name or IP address of the SMTP server. [Send Mail Task] Error: No recipient is specified. Error: The connection "smtp01.frank.com" is not found. This error is thrown by Connections collection when the specific connection element is not found. Please help me out.

How have you specified the recipient? You didn't say anything about specifying one in the post responding to my inquiry for you to tell me EVERYTHING you set up in the Connection Manager and Task... Although I suppose I wasn't clear on that - I said exact, not all... Talk to me now on

hello todd sorry if i am missing some thing.. But this is how i am specifying in Send Mail Task. In send mail task i am giving. from address : scott.jr@franklin.com To : kris.berner@franklin.com CC:____ Bcc:___ Subject: Sample Message Source Type: Variable. Message Source: User:: Message Source Priority: Normal

Hmm. Very odd. The message you're getting keeps telling me that you've got something blank in there. Do you have an expression or configuration on the variable for the SMTP server address? Talk to me now on

There seems to be no issue with your TO field the error is strange. Anothr thing I noticed is for message source you are using: User:: Message Source , instead use: @[User:: Message Source] Let us know if this does solve ur issue.My Blog | Ask Me

Hello, I got the same problem. I tried everything (rewrite all the parameters to verify if there is a invisible strange character, add cc and bcc, and nothing). Finally I created again the package with the same parameters from 0 and everything worked fine. I am going to check again. This is weird.MVP MCT MCTS Daniel Calbimonte http://elpaladintecnologico.blogspot.com