You work as a database administrator at ABC.com. The ABC.com network consists of a single domain named
ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their environment.
You are in the process of creating a SQL Server Integration Services (SSIS) package. You have decided to
make use of Expression Task.
Which of the following is TRUE with regards to Expression Task?
A.
It creates and evaluates expressions that set variable values at runtime.
B.
It provides code to perform functions that are not available in the built-in tasks and transformations that SQL
Server Integration Services provides.
C.
It runs an application or batch file as part of a SQL Server Integration Services package workflow.
D.
It allows you to run SQL statements during package execution.
Explanation:
A.
It creates and evaluates expressions that set variable values at runtime.