Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

ERRORFILE option in BULK INSERT Expand / Collapse
Author
Message
Posted Tuesday, April 08, 2008 2:41 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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?

Thanks in advance..!!
vish
Post #481347
Posted Tuesday, April 08, 2008 8:44 PM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP 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
Posted Tuesday, April 15, 2008 10:01 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Tuesday, April 15, 2008 10:01 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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 »

Add to briefcase

Permissions Expand / Collapse