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 store ...
I'm working with an SSIS 2005 package which runs a stored procedure as an "Execute SQL" task. The sproc runs several other sprocs, some of which use PRINT statements to report status (this is so that ...