Job failed with followign error message

1

SSIS package execution failed with following Description:

SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Protocol error in TDS stream". An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Protocol error in TDS stream". An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Protocol error in TDS stream". Code: 0xC0047038 Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on OLE DB Source returned error code 0xC0202009. The component returned a failure code when the pipeline engine called PrimeOutput().

At this step SSIS package transfer data from one table to another table. Please advise, how to resolve it.

sql-server
ssis
asked on Stack Overflow Aug 20, 2014 by Mamnoon khan • edited Aug 20, 2014 by Raja Simon

1 Answer

0

This is how I solved the error

  1. Go to Start--> All Programs--> Microsoft SQL Server 2008--> Configuration Tools --> SQL Server Configuration Manager

  2. Expand the node SQL Native Client 10.0 Configuration

  3. Right click on "Aliases" and then select "New Alias..."

  4. Provide the IP address of the Source SQL server against the "Server" field and specify the Source server name against the "Alias Name" field.

  5. Choose the protocol as "NamedPipes" and click OK

answered on Stack Overflow Jul 5, 2018 by sree

User contributions licensed under CC BY-SA 3.0