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: