BCp command failing with error TCP Provider: An existing connection was forcibly closed by the remote host.

Jahnavi Sriram 1 Reputation point
2020-08-24T12:52:43.493+00:00

Hi,

I am running a bcp command using execute process task via SSIS package.The command copies data from sql table into a flat file. The table has around 100 million records.

The SSIS package ran successfully for about 2 weeks and then started failing with below error after copying couple of million rows.

TCP Provider: An existing connection was forcibly closed by the remote host.
SQLState = 08S01, NativeError = 10054
Error = [Microsoft][ODBC Driver 13 for SQL Server]Communication link failure
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC Driver 13 for SQL Server]Protocol error in TDS stream

Any help much appreciated!

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,575 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Monalv-MSFT 5,901 Reputation points
    2020-08-25T02:09:44.293+00:00

    Hi Jahnavi Sriram,

    The following links will be helpful:

    SQL Connectivity troubleshooting checklist

    An existing connection was forcibly closed by the remote host

    Best Regards,
    Mona

    ----------

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

  2. Stratos Matzouranis 36 Reputation points
    2020-08-26T13:06:26.683+00:00

    SSIS package running from SQL Server as registered package?

    If running from a remote machine try telnet the SQL Srv Service port.

    Also check firewall. You can try disable it for a run.

    0 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.