How to make ETL process?

Occasional Visitor

hile using AdventureWorks2017 as data source, make single table import ETL package into newly created database.
ETL has to succeed no matter how many times you will execute it.
Use stage table and “Execute SQL Task” for data merge (avoid using “Lookup task”).

Source table name: [AdventureWorks2017].[Sales].[SalesOrderDetail];

Target db name: “DB_Exercise” (use multiple filegroups if needed);
Target db objects schema name: “Sales”;
Target table name: [DB_Exercise].[Sales].[SalesOrderDetail] (add indexes (primary key is mandatory), partitioning if needed);

 

Also 


Managing transaction in “Execute SQL Task”, rollback transaction if error;
Load data in batches;
History table for [Sales].[SalesOrderDetail].

0 Replies