Hi, you can set the writer to UPDATE mode. Afterwards, you can set INSERT / UPDATE / DELETE as fme_db_operation on each feature. Condition: Having a unique ID for identifying which features to update, delete or insert.
Other possibility: Create a Pythonscript for emptying your destination featureclass It would be something like that: import arcgisscripting gp = arcgisscripting.create() gp.workspace = "path to your workspace" gp.deletefeatures_management(name of your featureclass) Afterwards, you can set that Python - file as "Startup python script" in workbench if you have FME 2007. If you have FME 2006GB, create a batch file calling your python file first and then executing your FME - File. Greetings, Jeff On 4/30/07, bjwotaski <[EMAIL PROTECTED]> wrote:
Hello, I am going to be running a process over and over again in which the source/input is 3 different datasets, one is a shapefile and two are personal geodatabases, all which are being combined into one new personal geodatabase after the attribution is changed/manipulated. I will run this process over and over again as updates come in, through an automated ETL process I am working on and the process works, however... The problem I am running into is that within the output/destination personal geodatabase every time I run the above process it adds the data into the existing personal geodatabase. What I want it to do is overwrite the existing data in the destination dataset, not add to it, Can this be done? If so what do I need to do? Can I set something in the parameters of the translation? I need to resolve this ASAP. Thanks, Brandon
-- Jeff Konnen INSER SA Switzerland +41 (0) 21 643 77 11
