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 ...

SQL Server 2008 Integration Services ships with the wonderful new Data Profiling Task. Much as the name implies, it profiles the data in a given table and returns a ton of useful information. 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 ...