Individual: Data Warehouse ETL develop an Export, Transform, and Load (ETL) package using Microsoft SQL Server
Fantastic news! We've Found the answer you've been seeking!
Question:
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."
Expert Answer:
Certainly I can guide you on how to create a simple ETL Export Transform and Load package using SQL Server Integration Services SSIS to achieve the ta... View the full answer
Posted Date:
