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
“stored in a control table”
That is why you cannot use the expression task and need a Execute SQL Task