April 8, 2008 at 2:41 am
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
April 8, 2008 at 8:44 pm
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.
April 15, 2008 at 10:01 pm
Hi
Is there any other way to write the erraneous rows in the csv file to any text file in SQL SERVER 2000.
April 15, 2008 at 10:01 pm
Hi
Is there any other way to write the erraneous rows in the csv file to any text file in SQL SERVER 2000...?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply