• 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.