Learn SQL Server Integration Services (SSIS) in 2 Hours - Complete Beginner's Guide to ETL

This video is a complete beginner's guide to SQL Server Integration Services (SSIS), where you will learn how to create ETL workflows in just 2 hours. From setting up your environment to deploying your packages, this course is perfect for those who want to get started with SQL Server Integration Services (SSIS) and understand how to create and manage ETL processes in SQL Server. This course is perfect for those who want to get started with SQL Server Integration Services (SSIS) and understand how to create and manage ETL processes in SQL Server. **What You'll Learn:** - How to set up SQL Server Integration Services (SSIS) and create your first project. - The difference between Control Flow and Data Flow tasks. - Importing data from different sources, including Excel and CSV files. - Performing data transformations such as lookups, conversions, and calculations. - Debugging and handling common errors in SQL Server Integration Services (SSIS). - Deploying and scheduling SQL Server Integration Services (SSIS) packages with SQL Server Agent. - Best practices for building and managing ETL workflows. This video will guide you through real-world examples, covering everything from the basics of SQL Server Integration Services (SSIS) architecture to more advanced topics like using script components and setting up project parameters. By the end of this tutorial, you'll have a solid foundation in SQL Server Integration Services (SSIS) and be ready to start building ETL solutions for your projects. **Chapters:** 0:10 - Introduction and Overview 1:30 - Definition of ETL 5:35 - Prerequisites for SSIS Setup 8:06 - Database Installation Example Setup 13:31 - Defining Business Requirements 15:47 - Creating SSIS Project in Visual Studio 19:20 - Building the Initial ETL Workflow 23:34 - Creating Warehouse Destination for ETL 25:14 - Adding Destination Component to Initial ETL 29:33 - ETL Workflow Enhancements 30:06 - Setting Up Project Connections 32:13 - Creating Data Source with SQL Join 37:54 - Debugging Common Development Errors 39:19 - Using Script Task in Control Flow 41:59 - Creating Flat File Tables for ETL 46:29 - Importing Excel Data (Exchange Rates) 48:52 - Data Conversion Techniques 52:40 - Importing Supplier Data from CSV File 57:25 - Debugging Errors (Part 2) 58:59 - Handling Duplicate Data 1:02:10 - Currency Conversion Overview 1:03:39 - Currency Conversion Using Control Flow 1:04:39 - Currency Conversion with Rate Lookup 1:06:40 - Debugging Currency Conversion with Data Viewer 1:07:44 - Handling No Matches Output from Lookup 1:08:48 - Combining Data with Union All 1:10:03 - Debugging Data Type Errors 1:11:19 - Calculating Exchange Rates with Derived Column 1:13:27 - Testing Lookup with No Match Output 1:15:41 - Supplier Data Lookup 1:19:51 - Handling Error Rows with Multi-Cast and Split 1:27:23 - Setting Project Parameters on Connection Strings 1:33:50 - Deploying the SSIS Package to SQL Server 1:34:50 - Installing the SSISDB Catalog 1:35:51 - Completing SQL Server Deployment 1:36:45 - Creating Environment Parameters for Deployment 1:41:49 - Creating SQL Server Agent Job 1:44:42 - Viewing Job History and Logs 1:46:32 - Scheduling the SQL Server Job 1:47:53 - Exchange Rates API Call with C# 1:50:34 - Working with the C# Script Component 1:55:43 - Inverting Exchange Rate in Derived Column 1:58:13 - Summary and Conclusion If you're interested in learning SQL Server Integration Services (SSIS) and want to master ETL workflows, this is the perfect place to start. Don't forget to like, subscribe, and leave a comment if you have any questions! **Resources Mentioned:** Installing Microsoft SQL Server Developer | Installation Series Ep1 [https://www.youtube.com/watch?v=05ZivSteGJg] Installing Microsoft SQL Server Management Studio (SSMS) | Installation Series Ep2 [https://www.youtube.com/watch?v=CqpURYqK_wU] Visual Studio SQL Server Data Tools Install (SSDT) | Installation Series Ep3 [https://www.youtube.com/watch?v=jcWfIZIQXso] Visual Studio SQL Server Integration Services Install (SSIS) | Installation Series Ep4 [https://www.youtube.com/watch?v=JMF5aBqBVYY] Github SSIS Folder [https://github.com/EmbarkBlue/JoeyBlue-SQL-Trainings/tree/main/Youtube/SSIS] LET'S CONNECT! GitHub: https://github.com/EmbarkBlue/JoeyBlue-SQL-Trainings Twitter: http://twitter.com/sql_by_joey Linkedin: http://linkedin.com/in/joeyblue SQLTrainingOnline: http://www.sqltrainingonline.com