Execute SQL tasks run stored procedures or SQL queries from SSIS packages. ... alter and drop database objects, as well as to prepare and truncate data and to return result sets.