Ok I can see a lot of you are having a look but no one appears to have an answer for this. I have tried all I can think of. Can anyone suggest a way around the problem i.e. a way to ignore the offending row(s) of data. I have attempted to move the loading data on error to an error file but I am unable to get the data to be pushed to the error file. My thinking this is because the error does not fall in the category of allowable error for funnelling this way (although I thought it would funnel any error this way).

Another note my associate at work was able to load the file using SQL 2000 but it appeared to ignore 300k out of 14 million records on the load. I am assuming those rows are offending rows of data. Looking for any suggestions here this is getting frustrating.

Thanks in advance.