I am updating a SQL Server database in FME Desktop 2015. My process runs successfully without error messages but nothing is actually written to the database (the log shows 125 features written). I am using fme_db_operation as the feature operation and the ID field as the match column. I don't know a whole lot about SQL, what am I missing here?
Page 1 / 1
What is the value of fme_db_operation? If it is INSERT, the feature is always written, but if it is UPDATE or DELETE it will all depend on if the value of the ID field is found in the existing data. If no value of that particular ID is found, nothing happens.
False alarm, the table is being updated but due to extra rows, it didn't seem like it.