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