Error with Post SQL on Input tool

Question

Has anyone had this sort of issue before? I have no idea...

Error: Input Data (1): Executing PostSQL:

"DELETE [this is my table]
WHERE [date_field] < (DateAdd(DD,-5,GETDATE()))"

: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]The transaction log for database '[database_name]' is full due to 'ACTIVE_TRANSACTION'.

Thanks! Any assistance would be appreciated 🙂

MonBrazier · Accepted Answer

Thanks! I actually solved my issue.  It turns out I was out of space in the SQL Logs on SQL Server.

The DELETE statement works as expected in the post sql part of the input tool 🙂

Thanks !