The Sales database includes a table named Products that contains 42 columns, and two
tables that record all product sales transactions. The database does not store aggregated
data. The database is continually maintained to provide optimal indexing. The database
server is sized appropriately.
The Marketing department requests a delimited text file that includes seven fields containing
product information from the Products table.
You have the following requirements:
Display the ProductID in the first column. Organize the remaining columns alphabetically by
column heading.
Sort rows in ProductID order.
Aggregate product units sold.
Minimize the time required to return the results.
You create a SQL Server Integration Services (SSIS) package and add the appropriate
connection managers and a Data Flow task.
You need to develop the Data Flow task.
What should you add to the Data Flow task? (More than one answer choice may achieve the
goal. Select the BEST answer.)

A.
A table-based OLE DB source; a Script component; and a Flat File destination.

B.
Only a SQL command-based OLE DB source and a Flat File destination.

C.
A table-based OLE DB source; Lookup, Aggregate, and Sort transformations; and a Flat
File destination.

D.
A SQL command-based OLE DB source; Aggregate and Sort transformations; and a Flat
File destination.