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
185
http://www.aiotestking.com/microsoft/what-should-you-use-to-set-the-variable/
Lots of discussion on this, but again it’s unclear what the question is asking. There is no system variable called currentdate, so it sounds like a user variable we’re supposed to get from a table in an azure database. In this case, we would use sql task to query for that date and set that value to user::currentdate.
Someone I respect, Slazenjer_m, wrote:
The answer is A. Use an Expression Task, and specify a System Variable using any of the default variable expressions (like, @[System::StartTime]) predefined in the SQL database.
I don’t think this is right. I don’t think we’re supposed to get the current date with a system variable or expression and set it to user::current date. I think we’re supposed to query for it from that azure control table because of this sentance:
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.
Again, this is question wording issue rather than how good are you at ssis.