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
its A.) Expression task
It is A the same Question 183
For me the answer is right, B. an Execute SQL task
http://sqlage.blogspot.it/2015/04/how-to-save-single-value-in-variable-in.html
the 2 questions are different Here we are referring to a table however question 183 is referring to a current execution date and i am 100 % sure that for the current exec date option you can easily do it via Expression task and it is simple. however here i am not sure that you can use table value in the expression task builder to refer to a table so maybe both answers are actuall correct
yeah. Both different.
To get the data from a database you need a Execute SQL Task. You ask the database, get the result and assign to the variable.
-> B
A – Expression task and CurrentDate = Now()
B.
an Execute SQL task
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.
This looks like you need to query ‘the Date column of a stored control table’ of Windows Azure SQL Database, in order to retrieve the CurrentDate values.
Really, I have to concur with option B, cos it seems a Execute SQL task would be needed for this!!
I think both 172 and 183 are right, they answer each situation in the right way
I think it is asking about setting the CurrentDate Variable, rather than retrieving it. so possibly an Expression Task.