<div>
in your bulk insert statement add MAXERRORS &nbsp;option and set it to a higher value. if MAXERRORS is not set default is 10 errors, after 10 errors bulk insert stops execution.<br />

</div>


<div>
Try this - <br />
<a href="http://www.developer.com/db/article.php/724711/Microsoft-SQL-Server-2000-Error-Messages.htm" rel="ugc">http://www.developer.com/db/article.php/724711/Microsoft-SQL-Server-2000-Error-Messages.htm</a><br />
<a href="http://www.sommarskog.se/error-handling-I.html" rel="ugc">http://www.sommarskog.se/error-handling-I.html</a>
</div>


<div>
Is this correct? I still only get 10 errors. &nbsp;Sorry I'm sure it's simple but I'm very new to SQL. &nbsp;Thanks.<br />
<br />
Bulk insert Catalogue from '\\bccfile\Information Technology\ix\Text Files to Import\catalogue.txt'<br />
<br />
WITH (MAXERRORS = 250, Firstrow = 1, FIELDTERMINATOR = '|', ROWTERMINATOR = '\n')<br />

</div>


<div>
yes that's correct.<br />
with the above sql your bulk insert should run either till it encounters 250 errors or completes inserting all the records from the text file.<br />
<br />
what errors are shown in your message window? 
</div>


<div>
These are the errors that I get:<br />
<br />
Only 10 are displayed but I know that there are 137 records missing when I do the insert. &nbsp;I presume there should be at least one error msh for each of these records.<br />
<br />
Msg 4863, Level 16, State 1, Line 1<br />
Bulk insert data conversion error (truncation) for row 1, column 3 (ID_Prefix).<br />
Msg 4863, Level 16, State 1, Line 1<br />
Bulk insert data conversion error (truncation) for row 1712, column 34 (Whole_Part).<br />
Msg 4863, Level 16, State 1, Line 1<br />
Bulk insert data conversion error (truncation) for row 2110, column 70 (Created_By).<br />
Msg 4863, Level 16, State 1, Line 1<br />
Bulk insert data conversion error (truncation) for row 2128, column 70 (Created_By).<br />
Msg 4863, Level 16, State 1, Line 1<br />
Bulk insert data conversion error (truncation) for row 2182, column 34 (Whole_Part).<br />
Msg 4863, Level 16, State 1, Line 1<br />
Bulk insert data conversion error (truncation) for row 2183, column 34 (Whole_Part).<br />
Msg 4863, Level 16, State 1, Line 1<br />
Bulk insert data conversion error (truncation) for row 2184, column 34 (Whole_Part).<br />
Msg 4863, Level 16, State 1, Line 1<br />
Bulk insert data conversion error (truncation) for row 2185, column 34 (Whole_Part).<br />
Msg 4863, Level 16, State 1, Line 1<br />
Bulk insert data conversion error (truncation) for row 2186, column 34 (Whole_Part).<br />
Msg 4863, Level 16, State 1, Line 1<br />
Bulk insert data conversion error (truncation) for row 2187, column 34 (Whole_Part).<br />
Msg 2601, Level 14, State 3, Line 1<br />
Cannot insert duplicate key row in object 'Catalogue' with unique index 'IX_Catalogue_ID_Number'.<br />
The statement has been terminated.<br />

</div>


<div>
Thanks Appari the maxerror option was working fine. &nbsp;You were corrct about the constrain checking issue. &nbsp;I have managed to fix all the errors. &nbsp;<br />
<br />
Thanks again.
</div>


<div>
<div class="content wysiwyg-content">
I am trying to do a bulk insert of 2339 records. I managed to insert 2002 records.<br />
In the message's section at the bottom it shows a max of 10 errors. &nbsp;What do I have to do so that I'm able to see the maximum number of errors?<br />
<br />
Thanks
</div>
</div>


I am trying to do a bulk insert of 2339 records. I managed to insert 2002 records.
In the message's section at the bottom it shows a max of 10 errors.  What do I have to do so that I'm able to see the maximum number of errors?

Thanks

How do you see max number of errors after executing sql statement?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.