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.
