03-20-10, 03:06 #1Registered User
- Join Date
- Mar 2010
Unanswered: Error file not populated using bcp utility
I am using bcp utility to export VIEW data to text file. I am using -e err_file option to generate error file. Error file is generated but errors are not logged in to the file.
Specifies the full path of an error file used to store any rows that the bcp utility cannot transfer from the file to the database. Error messages from the bcp command go to the workstation of the user. If this option is not used, an error file is not created.
Does this mean that error file will be generated while importing data from file to database. Not for exporting?
waiting for reply...
03-23-10, 09:07 #2Registered User
- Join Date
- Jul 2003
- San Antonio, TX
Error file gets created when using "-e" switch, if bcp starts successfully, but encounters errors while extracting data into a destination file. Just like msdn says, only records that failed to be extracted, will be stored into the file (very rare case, usually you'll encounter errors when loading data into the database from another source, like text file). If no errors were encountered, the error file will have the size of 0."The data in a record depends on the Key to the record, the Whole Key, and
nothing but the Key, so help me Codd."