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: 
why we did’t use
Execute T-SQL statement task ?
it is more efficient and takes less memory
can you guys answer me
Thanks
0
0
The reasons why it can’t be ‘Execute T-SQL statement task’ are:
1/ Parameterized queries can be used only in Execute SQL Tasks
2/ It is against SQL Azure that requires an SQL Mobile connection. The ‘Execute T-SQL statement task’ relies only on an ADO.NET connection.
0
0
I guess because of T-SQL statement task
doesn’t support parameters.
0
0
+1 Dim
0
0
MSDN:”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.”
https://msdn.microsoft.com/en-us/library/ms139753%28v=sql.120%29.aspx
0
0
Nice job Briquet good find
0
0
+1
0
0
+1
0
0