I’m trying to create a Python script that runs after hours to update a standalone GIS table (SDE MSSQL). Currently all of the rows are deleted and an updated CSV file is appended to the GIS table, basically a wipe and replace. That will no longer be an option because we’re only exporting out the current year, so prior years must remain in the GIS table. Is it possible to append new and either update or delete existing rows within the GIS table using the CSV, if so could someone provide some guidance?
I have a ticket number field that can be used as a reference between the GIS and the export.