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
Explanation:
Ref: http://msdn.microsoft.com/en-us/library/ms141214.aspx
http://blog.sqltechie.com/2012/11/expression-task-in-ssis-2012.html