We are loading a flat file ( Pipe delimited ) , till today if file had any issues , load failed with error and NO record(S) loaded to processing table. But today we had a BCP failure (due to right truncation error , file has 26 records) and just one record loaded and errors logged in log file. Just wondering how one record loaded when BCP file load failed. My understanding is BCP command will not load a single record if file had any issues ( format / length of columns is greater than specified column size in destination table ) , Can some one help here?