I think i could not get the question correct, as BCP we can append data into table. but it overrites flat file.:):)