Execute SQL tasks run stored procedures or SQL queries from SSIS packages. A task executes any SQL statements that have been passed to it in sequential order. It provides you with a handy way to ...

445873 – SQL Task closes retained connections of type ADO.NET and ODBC ExecuteSql task needs to release the connection it is using at the end of the task.

I have a cleanup task that occurs before a backup task in a Maint Plan. The cleanup task deletes all .bak files >1 week old, but that isn't happening. The log shows as success, but no further ...