On 11/07/2011 15:19, Bryan wrote:

> The file I am importing is 480MB and contains 6 million records. The
> whole file is imported with a single transaction, and each record has
> a save point wrapped around it. The save point can "rollback" if a
> detail record is found to have had an error, otherwise it is
> "committed".

Hi Bryan, a couple of questions. What type of file are you importing?
Excel, text, sqlserver? Are there date fields with inconsistent date
formats, e.g. the odd British or US format? I've had this happen and
have had to create error-handling for that purpose. Are there any null
fields where they are not allowed?
Another question - you allow the file to be imported even if there are
some "bad" records, is that correct?

I think we need more details before making a sensible suggestion.

Alan J Davies
Aldis