delete and load in odbc

[smohd1338]

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?

[ray.wurlod]

You could use Before/SQL to issue a DELETE statement (or even TRUNCATE if the database supports that).

[aartlett]

And you could use File Schema Files and RCP to make a generic job and correct parameters to have 1 generic job to support this.

I just finished doing this for 15 files in, and using SQL in a file handled a generic delta load for updates and deletes.