Send Email task failure Error: 4.4.1 connection timed out

Arnya 0 Reputation points
2023-02-25T23:08:04.5033333+00:00

I use an SMTP connection manager and Send Mail task to send emails to customer approx 5000 emails.

The SSIS package runs successfully when the elapsed run-time for the package is less than 10 minutes.

The Send Email task fails because the SMTP server closes the connection after 10 minutes.

An error occurred with the following error message."Service not available, closing transmission channel. The server response was: 4.4.1 Connection timed out.

Any suggestions to fix this issue.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. ZoeHui-MSFT 41,491 Reputation points
    2023-02-27T06:22:25.6066667+00:00

    Hi @Arnya,

    What smtp server are you using?

    If you are using Exchange server, you may check it out here.

    If you are using your own server in your company, you may look for help from your technical engineers.

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    1 person found this answer helpful.
    0 comments No comments

  2. Olaf Helper 47,436 Reputation points
    2023-02-27T07:30:21.05+00:00

    to send emails to customer approx 5000 emails.

    5000 emails? Mhh, so you may get classified as Spammer?

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.