Share via

AdventureWorks2019 -> AdventureWorksDW2019 ETL?

rob m 256 Reputation points
2022-01-14T02:39:15.66+00:00

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)

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,670 questions
0 comments
Accepted answer
  1. Olaf Helper 44,296 Reputation points
    2022-01-14T05:44:49.903+00:00

    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".

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. AmeliaGu-MSFT 13,976 Reputation points Microsoft Vendor
    2022-01-14T03:33:17.423+00:00

    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.

    0 comments
  2. Tom Phillips 17,731 Reputation points
    2022-01-14T14:11:16.99+00:00

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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.