As I know also if I have a duplicate key it should be considered as error and it should be skipped and the statment should complete normally, I am testing it on a simple table with 2 columns integer(PK)and nvarchar(2), my statment is
"BULK INSERT test.dbo.[testingbulk]
FROM 'c:\bulk.txt'
WITH
( datafiletype = 'char',
FIELDTERMINATOR = ',',
maxerrors = 1000,
KEEPIDENTITY
)"
thanx,
Quote:
quote:Originally posted by joefawcett
As I understand it MaxErrors only means the procedure carries on after errors, it doesn't let you break constraints. Can you show your BULK INSERT query and your source and target table structure?
--
Joe
|