Checkpoints not restarted after the point of failure in SSIS -

i have package 1 execute sql task , 1 dft. inside dft loading data text file emp table.

my text file data has 9 records

1, india   2, pakistan   3, afgha   4, asia   5,   6,europe   7, australia   

structure of table

id int not null,   name varchar not null    

i have set required checkpoint properties dft

checkpoint filename -- given   checkpoint usage--ifexists   save checkpoints -- true   failpackage on failure-- true    

now issue when run package data gets loaded table first 4 records , package fails, , checkpoint file created. next time when restart package, after making changes text file, replacing null value data.

5, england   

instead of loading data 5th record, records gets loaded table. actually, since had failure after 4th record, after restarting package , want data 5th record instead starting.

set dft transaction option required