delete and load in odbc
Posted: Sat Aug 03, 2013 11:13 am
hi,
I have this scenario where i will get a file and will load into table, this job runs daily, everyday when it loads it has to delete all old data,completely erase andinser only new reords. i gave "delete and insert" , that doesnt seem to work? how shall this be acheived?
I have this scenario where i will get a file and will load into table, this job runs daily, everyday when it loads it has to delete all old data,completely erase andinser only new reords. i gave "delete and insert" , that doesnt seem to work? how shall this be acheived?