I have a repetitive monthly task of updating a handful of feature classes with updated data. Typically I delete all records and simply load in the new data. Is there a tool/function that I can drag into model builder that will delete all records without creating and empty feature and allow me to load the new data in from a shapefile.
So far I have not been able to find a tool that will allow me to delete all records and not receive and empty feature class error.
It really is that simple of a task, just time consuming, repetitive, and needs to be automated. I will keep looking, I could do this with a Python script likely, but I would like to utilize model builder a little more and I am still a rookie with python
Data resides in a versioned SDE environment. I have tried to run the delete records tool, which seems to work, however, to load the data I have tried to used the Append tool, however, I am trying to run it on my own version as to not disrupt any other users.
I get an error that I must be the owner of the table. I am not too comfortable running it on the default version (owner), I am not sure how to get around this.
Typically I delete records from each feature class individually, load, all in my own version and then post.