While configuring SSIS package please right click on SSIS's destination > edit > error output > on error select ignore failure and in "set this value to selected cells" drop...