Originally posted by fadace
Use the -o option putting the error msg in a file, and then analyze it.
Since the bulk import will be happened every day and from varies users. The manipulation of text file will be more and more for doing bulk import.
To do the bulk import, there are two files to be handled, one for actual input data from excel to front-end (VB) and other for output file of BCP. Everyday number of files will be increased, and in some cases we need to know which data caused error.
Apart from these concepts of BCP, are any other techniques?