sql server dts: 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

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

[quoted text, click to view]