Hi

I am trying to import a table from SQL Server 2000 (it got about 40 Millions
rows) to SQL Server 2005 table, I am getting this error after transforming
for about 1 hr.

I used simple data flow task with default settings.

Any help

[SQL Server Destination [283]] Error: An OLE DB error has occurred. Error
code: 0x80040E14. An OLE DB record is available. Source: "Microsoft SQL
Native Client" Hresult: 0x80040E14 Description: "Cannot fetch a row from
OLE DB provider "BULK" for linked server "(null)".". An OLE DB record is
available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14
Description: "The OLE DB provider "BULK" for linked server "(null)" reported
an error. The provider did not give any information about the error.". An OLE
DB record is available. Source: "Microsoft SQL Native Client" Hresult:
0x80040E14 Description: "Reading from DTS buffer timed out.".

Thanks
Kalyan

Hello Kalyan,

Are you using the SQL Server destination? if you are then can you up the
timeout property or set it to 0 for no timeout?


Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com