InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 20:35:16 GMT20http://www.sqlservercentral.com/Forums/Topic481347-169-1.aspxHi Is there any other way to write the erraneous rows in the csv file to any text file in SQL SERVER 2000...?Tue, 15 Apr 2008 22:01:18 GMTvish-531091http://www.sqlservercentral.com/Forums/Topic481347-169-1.aspxHi Is there any other way to write the erraneous rows in the csv file to any text file in SQL SERVER 2000.Tue, 15 Apr 2008 22:01:07 GMTvish-531091http://www.sqlservercentral.com/Forums/Topic481347-169-1.aspxERRORFILE can be used in SQL 2005. See the following links[url]http://msdn2.microsoft.com/en-us/library/ms188365.aspx[/url][url]http://support.microsoft.com/kb/919775[/url][url]http://www.sqlservercentral.com/Forums/Topic447601-338-1.aspx[/url]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.Tue, 08 Apr 2008 20:44:39 GMTSQL ORACLEhttp://www.sqlservercentral.com/Forums/Topic481347-169-1.aspxHi All,I have used ERRORFILE option while using BULK INSERT commandin 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..!!vishTue, 08 Apr 2008 02:41:32 GMTvish-531091