December 26, 2012 at 10:00 pm
Hi,
SQL - SQL Server 2008 Standard Edition with Service Pack 1
I have tried to export all tables to another new database on same server..but one table does not properly exported..
please suggestion me how to resolve this issues..
Error Message
-------------
- Copying to [dbo].[BC_ShiftSummaryInfo] (Error)
Messages
Error 0xc0202009: Data Flow Task 6: 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 10.0" Hresult: 0x80004005 Description: "Protocol error in TDS stream".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Communication link failure".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "TCP Provider: An existing connection was forcibly closed by the remote host.
".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Communication link failure".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "TCP Provider: An existing connection was forcibly closed by the remote host.
".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Communication link failure".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "TCP Provider: An existing connection was forcibly closed by the remote host.
".
(SQL Server Import and Export Wizard)
Error 0xc0047038: Data Flow Task 6: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "Source 28 - BC_ShiftSummaryInfo" (275) returned error code 0xC0202009. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.
(SQL Server Import and Export Wizard)
Thanks
ananda
December 27, 2012 at 2:44 am
It seems there was a network issue.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 27, 2012 at 2:57 am
On Error log mention the different message during export data to another database on same server
Error: 7886, Severity: 20, State: 1.
Message
A read operation on a large object failed while sending data to the client. A common cause for this is if the application is running in READ UNCOMMITTED isolation level. This connection will be terminated.
December 27, 2012 at 3:11 am
Is this consistent behaviour? If you run the import/export wizard again for that single table, does it fail again?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 27, 2012 at 3:41 am
yes.. you catched me,, this particular table having consistancy error due to logical HD block courrpted..
so, Im trying to export to another table but export is failed due to consistancy error..
December 27, 2012 at 9:42 am
Post the complete result of this:
USE [YourDatabase];
DBCC CHECKDB WITH NO_INFOMSGS;
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply