trying to delete records from a SQL table using Output data tool but getting an error - "Missing incoming connections". Is there another tool that can be used to merely delete records from a table using sql query?
Solved! Go to Solution.
Maybe a Text Input tool feeding into a Dynamic Input? I've never tried to run an SQL DELETE command.
Or an Input Data tool?
Chris
If I understand correctly, you are trying to delete all records, correct?
The "Delete Data & Append" is designed to swap out the records for what is incoming into the tool. I believe, if there is an error during the append, the table will be left empty. But no one wants to have errors. :) You could instead have an empty table incoming into this tool. Alternatively, you could run a SQL statement with a DELETE statement.