I have an SSIS package that executes some sql statements (to drop and create
a table), reads in an xml source, sorts 2 elements and does a merge join on
the 2 sorts to combine them into one table. So far the largest file I have
managed to get through this process is 100mb. Here are the errors I get when
I try to process a 280mb file:

Error: 0xC0202009 at Extract XML, SQL Server Destination [6131]: 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.".



I need to be able to process between 1 and 2 gb ultimately, in one xml file.
Why am I hitting a limit at around 100Mb?


Regards, Sven