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".
AdventureWorks2019 -> AdventureWorksDW2019 ETL?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 50%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
rob m
261
Reputation points
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 | Other
Answer accepted by question author
-
Olaf Helper 47,616 Reputation points2022-01-14T05:44:49.903+00:00
2 additional answers
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
Tom Phillips 17,786 Reputation points2022-01-14T14:11:16.99+00:00 MS does not provide the ETL or SSIS packages used to create the sample databases.
-
rob m 261 Reputation points
2022-01-14T14:39:48.44+00:00 that is unfortunate, they must have that ssis code somewhere????
-
Dr. Sylvester Fernandes 0 Reputation points2023-09-18T11:32:49.9+00:00 Use the WorldWide Importers https://learn.microsoft.com/en-us/sql/samples/wide-world-importers-perform-etl?view=sql-server-ver16
they have everything, OLTP, OLAP, SSIS etc
Sign in to comment -
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 46%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
AmeliaGu-MSFT 14,011 Reputation points Microsoft External Staff2022-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.