You are designing a SQL Server Integration Services (SSIS) data flow to load sales transactions from a
source system into a data warehouse hosted on Windows Azure SQL Database. One of the columns in
the data source is named ProductCode.
Some of the data to be loaded will reference products that need special processing logic in the data
flow.You need to enable separate processing streams for a subset of rows based on the source product code.
Which data flow transformation should you use?
A.
Source Assistant
B.
Destination Assistant
C.
Audit
D.
Script Component
Explanation:
Script Component Transformation:
The transformation that uses script to extract, transform, or load data.
Note:
* SQL Server Integration Services provides three different types of data flow components: sources,
transformations, and destinations. Sources extract data from data stores such as tables and views in
relational databases, files, and Analysis Services databases. Transformations modify, summarize, and
clean data. Destinations load data into data stores or create in-memory datasets.
Incorrect:
Not A, Not B: No Data Transforms called Source Assistant or Destination Assistant
Not C: Not related to auditing