I’m creating a workspace that reads 7-8 tables from a file geodatabase and then writes them into tables in a SQL database. One of the tables is sometimes present and sometimes missing (that is expected). I need to create a workflow where when the table is present we write the data into the SQL table and when it is not present we just truncate that same table in the SQL database. I currently have a gdb reader connected to a tester that passes when fme_feature_type Like MSAG_To_RCL_Synchronization. This works when the table is there but when it’s missing the reader just closes and gives the message “The table name 'MSAG_To_RCL_Synchronization' could not be found in the Geodatabase as either a feature class or a table” and closes before any input gets to the tester. Any ideas on how to conditionally test if a table exist or not and then either write the data or truncate a SQL table.





