070-463 Real Exam Prep DEMO

Question 1: You are developing a SQL Server Integration Services (SSIS) package.
The package must run a parameterized query against a Windows Azure SQL Database database.
You need to use the least amount of development effort to meet the package requirement.
Which task should you use? (To answer, select the appropriate task in the answer area.)
Correct Answer:
Explanation
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/