ERRORFILE option in BULK INSERT

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » SQL Server Newbies » ERRORFILE option in BULK INSERT

ERRORFILE option in BULK INSERT

Rate Topic

Display Mode

Topic Options

Author

Message

vish-531091

Posted Tuesday, April 08, 2008 2:41 AM

Grasshopper

Group: General Forum Members
Last Login: Sunday, January 11, 2009 10:34 PM
Points: 16, Visits: 49

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

Post #481347

SQL ORACLE

Posted Tuesday, April 08, 2008 8:44 PM

UDP Broadcaster

Group: General Forum Members
Last Login: Friday, April 05, 2013 4:43 PM
Points: 1,473, Visits: 1,314

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.

Post #481997

vish-531091

Posted Tuesday, April 15, 2008 10:01 PM

Grasshopper

Group: General Forum Members
Last Login: Sunday, January 11, 2009 10:34 PM
Points: 16, Visits: 49

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

Post #485402

vish-531091

Posted Tuesday, April 15, 2008 10:01 PM

Grasshopper

Group: General Forum Members
Last Login: Sunday, January 11, 2009 10:34 PM
Points: 16, Visits: 49

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

Post #485403

« Prev Topic | Next Topic »

Permissions