{"repo":"phucvn16409/build-etl-using-ssis","free":true,"listed":false,"github":"https://github.com/phucvn16409/build-etl-using-ssis","clone":"git clone https://github.com/phucvn16409/build-etl-using-ssis.git","description":"Starter project for building an ETL pipeline using SSIS in Visual Studio 2019","language":"TSQL","stars":24,"topics":["data-engineering","data-warehouse","etl","etl-pipeline","etl-ssis","ssis","visual-studio"],"license":"MIT","category":"data-pipelines","readme_excerpt":"Build an ETL Pipeline using SSIS This project provides a comprehensive guide for building an ETL (Extract, Transform, Load) pipeline using SQL Server Integration Services (SSIS) in Visual Studio 2019 . --- 🎯 Goal The primary goal of this project is to provide a basic yet practical solution for anyone looking to build a new ETL pipeline using SSIS, with AdventureWorks 2019 as the sample data source. --- ✅ Prerequisites Make sure the following components are installed and properly configured: - Visual Studio 2019 Note: Visual Studio 2017 is also supported, but SSIS integration may behave differently. - SQL Server Integration Services (SSIS) Extension for VS 2019 👉 Install SSIS for Visual Studio 2019 - SQL Server (any supported edition) - SQL Server Management Studio (SSMS) - AdventureWorks 2019 Sample Database 📦 Download AdventureWorks2019.bak --- 🧭 Project Overview The dataset simulates a sample retail system for a bicycle company. The objective is to build an end-to-end ETL pipeline to generate a variety of reports: - Sales reports by employee - Sales reports by region - Number of orders per employee - Number of orders per region - Sales by product subcategory - Sales by product and region ETL Architecture Overview --- 🛠️ First-time ETL Build the staging area, design the data warehouse, and create SSIS packages to perform initial extraction, transformation, and loading of data. ETL Process - First Run Steps: 1. Import source data into SSMS 2. Design a data warehouse sche","default_branch":null,"files":null,"tree":[],"storefront":"/r/phucvn16409","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/phucvn16409/build-etl-using-ssis/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}