Individual: Data Warehouse ETL

develop an Export, Transform, and Load (ETL) package using Microsoft^® SQL Server Integration Services that:

• Exports the contents of each table to separate CSV files
• Archives the contents of each table to separate archives tables in the data warehouse SQL Server^® database

Use the test data you created in the Week One assignment, "Data Warehouse High-Level Design."

Complete the assignment in Microsoft^® SQL Server^® as follows:

• Capture screenshots of all SQL Server Integration Service tasks
• Paste the screenshots into a Microsoft^® Word document

Compress the exported CSV files and the document with the screenshots into an appropriately named ZIP file.

Note: You will use this assignment and the Week One Individual Assignment, "Data Warehouse High-Level Design," to complete the Week Four Individual Assignment, "Data Warehouse Data Mining Strategy."