Running Parameterized SQL Commands
SQL statements and stored procedures frequently use input parameters, output parameters, and return codes. The
Execute SQL task supports the Input, Output, and ReturnValue parameter types. You use the Input type for input
parameters, Output for output parameters, and ReturnValue for return codes.
Ref: http://msdn.microsoft.com/en-us/library/ms141003.aspx
In SSIS there are two tasks than can be used to execute SQL statements: Execute T-SQL Statement and Execute SQL.
What is the difference between the two?
The Execute T-SQL Statement task tasks less memory, parse time, and CPU time than the Execute SQL task, but is not
as flexible. If you need to run parameterized queries, save the query results to variables, or use property expressions,
you should use the Execute SQL task instead of the Execute T-SQL Statement task.
Ref: http://www.sqlservercentral.com/blogs/jamesserra/2012/11/08/ssis-execute-sql-task-vs-execute-t-sql-
statement-task/