Output data tool - missing incoming connections

[nareshbasnet]

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?

[ChrisTX]

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

[LindonB · Accepted solution]

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.