AdventureWorks2019 -> AdventureWorksDW2019 ETL?

Question

Microsoft provides some sample DBs
https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver15&tabs=ssms

I downloaded
AdventureWorks2019 and AdventureWorksDW2019

where is the etl (stored procs or SSIS)

Answer 1

Hello,
You can find all sample for SQL Server at GitHub: https://github.com/microsoft/sql-server-samples
BTW, AdventureWorks is a bit outdated, new sample is "World Wide Importer".

Answer 2

Hi robm-4957,

You can use AdventureWorksDW database as sample database for SSIS ETL package.
Here is tutorial using the AdventureWorksDW database as an example.

Best Regards,
Amelia

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

MS does not provide the ETL or SSIS packages used to create the sample databases.