Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Create ETL Packages with SSIS,SSDT,SQL Server, Visual Studio
149 students

Create ETL Packages with SSIS,SSDT,SQL Server, Visual Studio

Design, Build, Run ETL Packages Using Microsoft Data Integration Tools: SSIS, SSDT , SQL Server, Visual Studio
Created byBluelime Learning Solutions
Last updated 3/2026
English

What you'll learn

  • Understand the core concepts of ETL and how they apply to real-world data integration scenarios.
  • Identify use cases for ETL in business intelligence, reporting, and data warehousing.
  • Set up a complete BI development environment, including SQL Server, SSMS, SSDT, and Visual Studio.
  • Download and install SQL Server and SSMS correctly and connect to your database instance.
  • Install and configure Visual Studio and SSDT, enabling the development of SSIS packages.
  • Restore sample databases to practice data extraction and transformation scenarios.
  • Create a new SSIS project within Visual Studio using SQL Server Data Tools.
  • Explore and analyze sample datasets to understand the data structure before building ETL logic.
  • Configure various connection managers in SSIS, including Flat File and OLE DB connections.
  • Design and build basic ETL workflows using the Control Flow and Data Flow tabs in SSIS.
  • Extract data from flat files and load it into SQL Server using SSIS Data Flow tasks.
  • Use Lookup transformations to enrich data by matching it with reference data from other sources.
  • Apply best practices for annotating and formatting SSIS packages to enhance readability and maintainability.
  • Understand the structure of an SSIS package and how each component contributes to the workflow.
  • Gain confidence in using Microsoft’s BI tools to develop, test, and maintain real-world data integration projects.

Course content

4 sections • 26 lectures • 1h 37m total length

  • Introduction1:01
  • What is ETL? Key Concepts & Use Cases0:32
  • Overview of the Microsoft BI Stack1:17
  • Introduction to SSIS, SSDT, SQL Server & Visual Studio1:02

Requirements

  • Basic understanding of databases – Familiarity with tables, rows, columns, and basic database concepts.
  • Some experience with SQL – Ability to write simple SELECT queries is helpful, but not mandatory.
  • General computer literacy – Comfort with installing software and navigating the Windows environment.
  • Logical thinking and attention to detail – Important for troubleshooting, data validation, and workflow building.
  • A Windows-based PC or laptop – Required for running SQL Server, SSMS, and Visual Studio. (Windows 10 or 11 recommended)
  • Stable internet connection – For downloading software, sample files, and receiving updates

Description

Are you looking to break into the world of data integration, business intelligence, or data engineering? Do you want to learn how to design and build professional ETL (Extract, Transform, Load) workflows using Microsoft’s powerful BI tools? This hands-on course will equip you with the skills and knowledge to confidently create ETL packages using SQL Server Integration Services (SSIS), SQL Server Data Tools (SSDT), SQL Server, and Visual Studio.

Whether you're a beginner or someone with some experience in data or SQL, this course is designed to take you from foundational concepts to practical, real-world implementation. You'll learn how to set up your development environment from scratch—including installing SQL Server, Management Studio, and Visual Studio with SSDT templates. From there, you’ll dive into building and managing ETL packages that can extract data from flat files or databases, transform it with business rules, and load it into SQL Server for analysis or reporting.

Throughout the course, you’ll work with real sample databases and step-by-step labs to reinforce your learning. You’ll gain a solid understanding of SSIS components like Control Flow, Data Flow, Connection Managers, and Transformations. You’ll also learn how to work with Lookup transformations, test and debug your packages, and format them for maintainability and clarity.

By the end of this course, you’ll be able to:

  • Understand key ETL concepts and Microsoft’s BI architecture.

  • Configure a full development environment using free Microsoft tools.

  • Create and manage SSIS projects and packages in Visual Studio.

  • Extract data from sources such as flat files and databases.

  • Apply transformations including data cleansing and lookups.

  • Load processed data into SQL Server tables or warehouses.

  • Test, format, and annotate ETL packages for clarity and performance.

This course is ideal for aspiring data analysts, data engineers, database developers, and IT professionals who want a practical, project-based introduction to ETL using Microsoft tools. It’s also perfect for students or career-changers looking to gain in-demand skills in data movement and integration.

No prior experience with SSIS or Visual Studio is required. A basic understanding of databases and simple SQL will be helpful but not mandatory—we’ll walk you through everything step by step.

Join us and start your journey into the world of data integration with one of the most widely used tools in enterprise environments. By the time you complete this course, you’ll have the confidence and skills to build ETL workflows that can support business insights, data reporting, and analytical decision-making.

Who this course is for:

  • Beginner to intermediate-level data analysts, developers, and BI enthusiasts looking to understand and work with Microsoft’s ETL ecosystem.
  • Students or recent graduates who want to break into the data engineering or business intelligence field.
  • Database professionals or SQL users who are comfortable writing queries and want to learn how to automate and scale data movement with SSIS.
  • IT professionals or system admins transitioning into data roles and needing foundational knowledge of SSIS and SQL Server.

Report abuse