Which task should you use?

HOTSPOT
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.)

HOTSPOT
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.)

Answer:



Leave a Reply 2

Your email address will not be published. Required fields are marked *


name

name

Correct one Execute T-SQL Statement task?

Shadab

Shadab

I don’t think the correct answer is “Execute T-SQL Statement task”
Please see the link below.
https://msdn.microsoft.com/en-us/library/ms139753.aspx

Excerpt
“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”

Hence, the correct answer is “Execute SQL Task”