What should you use to set the variable?

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?

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

Show Hint

Leave a Reply 4

Your email address will not be published. Required fields are marked *

ryahan

ryahan

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.

Reply

Jai

Jai

It has to be A

Reply

Yuriy

Yuriy

A – Expression task and CurrentDate = Now()

Reply