A SQL query task will execute any "raw" SQL code of your choice on the server and database that was setup using the connection string property.
Each query can be customized using that can get values from respondent answers.
You may also call stored procedure using the standard SQL Server stored procedure execute statement e.g: EXEC YourStoredProcedure @YourParam1, @YourParam2
