ERRORFILE option in BULK INSERT

• vish-531091

  Right there with Babe

  Points: 738

  More actions

  April 8, 2008 at 2:41 am

  #186128

  Hi All,

  I have used ERRORFILE option while using BULK INSERT command

  in SQL server 2000. It did compile without any errors.

  But, I am not sure if it generates the error file.

  Is ERRORFILE option is present with SQL server 2000 or is it with SQL server 2005? :unsure:

  Thanks in advance..!!

  vish

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  April 8, 2008 at 8:44 pm

  #800112

  ERRORFILE can be used in SQL 2005. See the following links

  http://msdn2.microsoft.com/en-us/library/ms188365.aspx

  http://support.microsoft.com/kb/919775

  http://www.sqlservercentral.com/Forums/Topic447601-338-1.aspx

  In SQL 2000, although running BULK INSERT ... WITH (ERRORFILE ...) does not give us any error, the system ignore it. To use errorfile (-e) in SQL 2000, you may consider to use BCP instead.

• vish-531091

  Right there with Babe

  Points: 738

  More actions

  April 15, 2008 at 10:01 pm

  #802877

  Hi

  Is there any other way to write the erraneous rows in the csv file to any text file in SQL SERVER 2000.

• vish-531091

  Right there with Babe

  Points: 738

  More actions

  April 15, 2008 at 10:01 pm

  #802878

  Hi

  Is there any other way to write the erraneous rows in the csv file to any text file in SQL SERVER 2000...?