You are implementing a SQL Server Integration Services (SSIS) 2012 package that loads data from
various flat files and a Windows Azure SQL Database database.
Daily transactions must be loaded into a staging database. All the SSIS tasks will use the CurrentDate
variable as the transaction date.You need to set the CurrentDate variable to the date stored in a control table of the Windows Azure SQL
Database database when the package starts. You need to achieve this goal by using the least amount of
development effort.
What should you use to set the variable?
A.
an Expression task
B.
an Execute SQL task
C.
a Script component
D.
a Script task
same question on 187, but answer is expression task. i think expression task is the right answer.
It actually isn’t the same. The difference is that question 187 just wants the current date, to be calculated on the spot. You would indeed use an expression task for that.
The important factor in this question is that the CurrentDate variable must be filled with a value from an external SQL table (“….to the date stored in a control table of the Windows Azure SQL”).
You must write an SQL-query to get that value and save it to your variable.
B is correct
DrsKafka is Correct. For this question, B is the correct answer.