HI,
I have created package in which i used SMTP to send File to particular Email ID but when i run the Package ,following Error Displays

SSIS package "Package.dtsx" starting.
Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning.
Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning.
Information: 0x40043006 at Data Flow Task, SSIS.Pipeline: Prepare for Execute phase is beginning.
Information: 0x40043007 at Data Flow Task, SSIS.Pipeline: Pre-Execute phase is beginning.
Information: 0x402090DC at Data Flow Task, Flat File Destination [1]: The processing of file "E:\report\Package\North\23_09_2009.txt" has started.
Information: 0x4004300C at Data Flow Task, SSIS.Pipeline: Execute phase is beginning.
Information: 0x40043008 at Data Flow Task, SSIS.Pipeline: Post Execute phase is beginning.
Information: 0x402090DD at Data Flow Task, Flat File Destination [1]: The processing of file "E:\report\Package\North\23_09_2009.txt" has ended.
Information: 0x4004300B at Data Flow Task, SSIS.Pipeline: "component "Flat File Destination" (1)" wrote 9561 rows.
Information: 0x40043009 at Data Flow Task, SSIS.Pipeline: Cleanup phase is beginning.
Error: 0xC002F304 at Send Mail Task, Send Mail Task: 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.16.5.124:25".
Task failed: Send Mail Task
Warning: 0x80019002 at package: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "package.dtsx" finished: Failure.



PLease suggest


Amit

Hi Amit,

"Error: 0xC002F304 at Send Mail Task, Send Mail Task: 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.16.5.124:25".
Task failed: Send Mail Task"


As per the error desc, Please try to ping your target server, may be there is some problem.

Let us know your observation.

Thanks-

I have to send mail to the Email id ,and i created package on same server .....

what sud i ping


Amit

Where is ur SMTP server?
Is it there on the same server as ur package?
Has the SMTP server been configured properly?

Amit,
There is a firewall blocking your access to 172.16.5.124 or that server does not have SMTP running on it.

You will need to talk to your network administrators.

From the machine you are running SSIS from, do this from a command prompt:

telnet 172.16.5.124 25

See if you get a response.

Hi Phil,

I got this after entering the telnet 172.30.80.211 25.

Connection failed,could not open the connection on port 25,i have checked that my SMTP port number s also correct.

Please help me.

HI same issue i got in my Server

I will do as u suggested

Connecting To 172.16.5.124 25.Could not open connection to the host, on port 23:
 Connect failed

but it is showng me this error pls find it