You are implementing a new 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 current execution date 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.
A Script component
C.
A Script task
D.
An Execute SQL task
For me the answer is D. An Execute SQL task.
http://sqlage.blogspot.it/2015/04/how-to-save-single-value-in-variable-in.html
0
0
A expression Task @ Dave don t really had time to look at your video but it sounded quiet complicated to go through.. this can easily be achieved Expression task and the question states You need to achieve this goal by using the least amount of development effort.
0
0
It has to be A
0
0
A – Expression task and CurrentDate = Now()
0
0