{"id":13063,"date":"2017-08-26T19:32:31","date_gmt":"2017-08-26T17:32:31","guid":{"rendered":"https:\/\/expert-only.com\/?page_id=13063"},"modified":"2026-05-10T12:55:46","modified_gmt":"2026-05-10T10:55:46","slug":"ssis-online-training","status":"publish","type":"page","link":"https:\/\/expert-only.com\/en\/ssis-online-training\/","title":{"rendered":"SQL Server Integration Services Course (SSIS)"},"content":{"rendered":"\n<p class=\"has-text-align-center\"><strong><em>Learn SQL Server Integration Services and Microsoft BI development of packages with our online SSIS Course.<\/em><\/strong><\/p>\n\n\n\n<p>Enrol in our SQL Server Integration Services Course to master data integration and ETL using Microsoft Business Intelligence tools. And note that this SSIS online video training is made for beginners as well as more experienced BI developers who master other technologies.<\/p>\n\n\n\n<p>Discover the power of Microsoft&#8217;s leading ETL tool, through our in-depth SSIS lectures, with practical examples and SQL code. The exercises are explained step by step to allow smoother progress.<\/p>\n\n\n\n<p class=\"has-text-align-center\"><strong><a href=\"https:\/\/www.udemy.com\/course\/data-integration-with-ssis-sql-server-integration-services\/?referralCode=00C42EE09B35CC84BF93\" target=\"_blank\" rel=\"sponsored nofollow noopener\">Enrol today to learn Data Integration with SSIS (SQL Server Integration Services)<\/a><\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"422\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2023\/06\/ssis-course-image_422_text.jpg\" alt=\"SQL Server Integration Services Course - SSIS training full course on Udemy\" class=\"wp-image-29857\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2023\/06\/ssis-course-image_422_text.jpg 750w, https:\/\/expert-only.com\/wp-content\/uploads\/2023\/06\/ssis-course-image_422_text-300x169.jpg 300w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><figcaption class=\"wp-element-caption\"><strong><em>SSIS Training Full Course (SQL Server Integration Services) on Udemy<\/em><\/strong><\/figcaption><\/figure>\n<\/div>\n\n\n<p>Learn the essentials of creating and using DTSX packages for various data operations:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Loading flat files<\/li>\n\n\n\n<li>Managing Excel files<\/li>\n\n\n\n<li>Import and export of XML documents<\/li>\n\n\n\n<li>Transferring data between databases using DTSX packages<\/li>\n\n\n\n<li>And also exporting data and managing integration errors.<\/li>\n<\/ul>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_83 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/expert-only.com\/en\/ssis-online-training\/#practical-use-case-in-this-sql-server-integration-services-course\" >Practical Use Case in this SQL Server Integration Services Course<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/expert-only.com\/en\/ssis-online-training\/#what-is-sql-server-integration-services\" >What is SQL Server Integration Services?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/expert-only.com\/en\/ssis-online-training\/#1-sql-server-integration-services-course-introduction-and-environment-set-up\" >1. SQL Server Integration Services Course: introduction and environment set-up<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/expert-only.com\/en\/ssis-online-training\/#2-import-and-export-flat-files-with-ssis\" >2. Import and export flat files with SSIS<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/expert-only.com\/en\/ssis-online-training\/#3-importing-and-exporting-excel-files\" >3. Importing and exporting Excel files<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/expert-only.com\/en\/ssis-online-training\/#4-import-and-export-xml-documents\" >4. Import and export XML documents<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/expert-only.com\/en\/ssis-online-training\/#5-sql-server-integration-services-course-manage-logs-metadata-processes-and-errors\" >5. SQL Server Integration Services Course: manage logs, metadata, processes and errors<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/expert-only.com\/en\/ssis-online-training\/#6-ssis-variables-configurations-and-deployments\" >6. SSIS variables, configurations and deployments<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/expert-only.com\/en\/ssis-online-training\/#7-data-transformations-in-our-sql-server-integration-services-course\" >7. Data transformations in our SQL Server Integration Services Course<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/expert-only.com\/en\/ssis-online-training\/#8-zip-and-unzip-files-and-folders-with-ssis\" >8. ZIP and Unzip files and folders with SSIS<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/expert-only.com\/en\/ssis-online-training\/#9-full-end-to-end-bi-project-with-ssis-using-real-life-data\" >9. Full end-to-end BI project with SSIS using real-life data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/expert-only.com\/en\/ssis-online-training\/#10-training-bonuses-ssas-tabular-and-power-bi\" >10. Training bonuses: SSAS Tabular and Power BI<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-practical-use-case-in-this-sql-server-integration-services-course\"><span class=\"ez-toc-section\" id=\"practical-use-case-in-this-sql-server-integration-services-course\"><\/span>Practical Use Case in this SQL Server Integration Services Course<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>The courses are based on SQL Server 2019 and are gradually updated to the latest versions of MS SQL, i.e. SQL Server 2022. The current version is Microsoft SQL Server 2022.<\/p>\n\n\n\n<p>At Expert-Only.com, we offer IT courses and tutorials for both beginners and seasoned professionals, including our 100% online SSIS training. Enhance your data engineering skills with Microsoft BI tools like SSIS, SSAS, SSRS, and Power BI, and stay ahead in the ever-evolving IT industry.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-what-is-sql-server-integration-services\"><span class=\"ez-toc-section\" id=\"what-is-sql-server-integration-services\"><\/span>What is SQL Server Integration Services?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>SQL Server Integration Services abbreviated as SSIS is an ETL, or data loading tool that can be used to copy and transform data from one location to another. SSIS is a very powerful and flexible tool that can be used for many different purposes.<\/p>\n\n\n\n<p>Its main purpose is to load data into databases, or to transfer it from one data source to another. Here we use SQL Server database and tables as main sources and targets.<\/p>\n\n\n\n<p>It can also extract, transform and load data from other sources such as flat files (CSV files, Excel files, etc.), but also different database vendors using specific connectors, like <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/integration-services\/data-flow\/oracle-connector?view=sql-server-ver16\" target=\"_blank\" rel=\"noreferrer noopener\">Oracle<\/a>, <a href=\"https:\/\/marketplace.visualstudio.com\/items?itemName=KingswaySoft.SSISIntegrationToolkitforSalesforce\" target=\"_blank\" rel=\"noreferrer noopener\">Salesforce<\/a> or <a href=\"https:\/\/zappysys.com\/blog\/read-sap-s4-hana-data-ssis-cloud-odata-rest-api\/\" target=\"_blank\" rel=\"noreferrer noopener\">SAP HANA<\/a> for example.<\/p>\n\n\n\n<p>It can also be used for tasks such as backing up data, copying data from one database to another or archiving logs. Technically, it is a feature of SQL Server that helps automate data-related processes from one system to another, and broadly, any scriptable task.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-1-sql-server-integration-services-course-introduction-and-environment-set-up\"><span class=\"ez-toc-section\" id=\"1-sql-server-integration-services-course-introduction-and-environment-set-up\"><\/span>1. SQL Server Integration Services Course: introduction and environment set-up<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Before we dive into the SSIS online training agenda, to learn about data integration and develop your first project, start by installing the Microsoft SQL Server BI development environment. In the next paragraph, we list the 3 necessary software packages.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Overview of the SSIS course<\/li>\n\n\n\n<li>Introduction to BI and SSIS<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-1-1-set-up-integration-services-development-environment-on-windows\"><em>1.1 Set up Integration Services development Environment on Windows<\/em><\/h3>\n\n\n\n<p>Indeed the first part of the introduction section is all about the development setup, a necessary step for data management and integration. All the software is free, you can download it on your Windows desktop, laptop or Server.<\/p>\n\n\n\n<p>Check the <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/sql-server\/install\/hardware-and-software-requirements-for-installing-sql-server-2022?view=sql-server-ver16\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">minimum hardware and software requirements<\/a> to be sure they are met by your machine specs.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Download and install SQL Server 2022 Developer Edition<\/strong><\/li>\n\n\n\n<li><strong>Download and install SQL Server Management Studio 19 (SSMS)<\/strong><\/li>\n\n\n\n<li><a href=\"https:\/\/expert-only.com\/en\/ssis\/install-ssis-in-visual-studio-2019\/\"><strong>Install Visual Studio 2022 and SSIS projects extension<\/strong><\/a><\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-1-2-create-basic-ssis-packages\"><em>1.2 Create basic SSIS packages<\/em><\/h3>\n\n\n\n<p>Then we learn SSIS package basics, how to create a solution, a project and a package with simple control flows and data flows. The main elements of a package are control flows and data flows. Typically having one or more sources and one or multiple targets.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/expert-only.com\/en\/ssis\/create-ssis-project-visual-studio-2019\/\"><strong>Create an SSIS project and package with Visual Studio 2019<\/strong><\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/expert-only.com\/en\/ssis\/create-a-simple-ssis-data-flow\/\"><strong>Create a simple SSIS package with a data flow<\/strong><\/a>\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/expert-only.com\/en\/ssis\/how-to-connect-to-a-sql-server-database-using-ssis\/\" type=\"post\" id=\"11345\">Including how to connect to a database using SSIS<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"720\" height=\"580\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-12-execute-xml-file-export.jpg\" alt=\"SQL Server Integration Services Course to learn data integration with Microsoft BI Stack\" class=\"wp-image-12953\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-12-execute-xml-file-export.jpg 720w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/10\/ssis-export-table-to-xml-12-execute-xml-file-export-300x242.jpg 300w\" sizes=\"auto, (max-width: 720px) 100vw, 720px\" \/><figcaption class=\"wp-element-caption\"><strong><em>SSIS Online Training to learn data integration using the Microsoft BI Stack<\/em><\/strong><\/figcaption><\/figure>\n<\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-2-import-and-export-flat-files-with-ssis\"><span class=\"ez-toc-section\" id=\"2-import-and-export-flat-files-with-ssis\"><\/span>2. Import and export flat files with SSIS<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>In this section, these SSIS courses are all about flat file management in BI and DWH field (CSV or TXT for example). And especially the import of data from an external source to a database. In these examples, the target database is a MS SQL database.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Flat files definition and integration key points (including common errors)<\/strong><\/li>\n\n\n\n<li><a href=\"https:\/\/expert-only.com\/en\/ssis\/import-csv-file-into-sql-server-with-ssis\/\"><strong>Import a CSV or TXT file into a SQL Server table<\/strong><\/a><\/li>\n\n\n\n<li><strong><a href=\"https:\/\/expert-only.com\/en\/ssis\/export-sql-data-in-csv-with-ssis\/\">Export data from a SQL Server table into a CSV file using SSIS<\/a><\/strong><\/li>\n\n\n\n<li><strong>Create an SSIS loop to load multiple flat files with one data flow<\/strong><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-3-importing-and-exporting-excel-files\"><span class=\"ez-toc-section\" id=\"3-importing-and-exporting-excel-files\"><\/span>3. Importing and exporting Excel files<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Introduction to Excel files integration and export with SSIS<\/strong><\/li>\n\n\n\n<li><a href=\"https:\/\/expert-only.com\/en\/ssis\/access-database-engine-2016-excel-driver\/\"><strong>Download, install and check 2016 Excel drivers for SSIS<\/strong><\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/expert-only.com\/en\/ssis\/export-sql-server-data-to-excel\/\"><strong>Export data from a SQL Server table into an Excel file<\/strong><\/a><\/li>\n\n\n\n<li><strong>Manage the Excel columns data type detection with SSIS<\/strong><\/li>\n\n\n\n<li><strong>Package to import specific Excel cells into a SQL Server table<\/strong><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-4-import-and-export-xml-documents\"><span class=\"ez-toc-section\" id=\"4-import-and-export-xml-documents\"><\/span>4. Import and export XML documents<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>This SQL Server Integration Services training explains step by step how to deal with XML documents for import and export.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong><a href=\"https:\/\/www.udemy.com\/course\/data-integration-with-ssis-sql-server-integration-services\/?referralCode=00C42EE09B35CC84BF93\" type=\"link\" id=\"https:\/\/www.udemy.com\/course\/data-integration-with-ssis-sql-server-integration-services\/?referralCode=00C42EE09B35CC84BF93\" rel=\"sponsored nofollow noopener\">XML format introduction and how to manage it with SSIS<\/a><\/strong><\/li>\n\n\n\n<li><strong>Import an XML file into a SQL Server table using SSIS<\/strong><\/li>\n\n\n\n<li><strong>Export data from a SQL Server table into an XML document<\/strong><\/li>\n\n\n\n<li><strong>Export SQL Server XML data into an XML document with SSIS<\/strong><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-5-sql-server-integration-services-course-manage-logs-metadata-processes-and-errors\"><span class=\"ez-toc-section\" id=\"5-sql-server-integration-services-course-manage-logs-metadata-processes-and-errors\"><\/span>5. SQL Server Integration Services Course: manage logs, metadata, processes and errors<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong><a href=\"https:\/\/www.udemy.com\/course\/data-integration-with-ssis-sql-server-integration-services\/?referralCode=00C42EE09B35CC84BF93\" type=\"link\" id=\"https:\/\/www.udemy.com\/course\/data-integration-with-ssis-sql-server-integration-services\/?referralCode=00C42EE09B35CC84BF93\" target=\"_blank\" rel=\"sponsored nofollow noopener\">SSIS Video Training introduction to Logs, Metadata, Process and Errors<\/a><\/strong><\/li>\n\n\n\n<li><strong>Activate and read SQL Server logging (including SQL Server provider and XML)<\/strong><\/li>\n\n\n\n<li><strong>Activate SSIS log using XML dynamic file names<\/strong><\/li>\n\n\n\n<li><strong>Staging (ODS) to Data warehouse (DWH) process with custom metadata<\/strong><\/li>\n\n\n\n<li><strong>Managing SSIS packages errors best practices <\/strong><\/li>\n\n\n\n<li>Quiz on SSIS and log management<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-6-ssis-variables-configurations-and-deployments\"><span class=\"ez-toc-section\" id=\"6-ssis-variables-configurations-and-deployments\"><\/span>6. SSIS variables, configurations and deployments<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong><a href=\"https:\/\/www.udemy.com\/course\/data-integration-with-ssis-sql-server-integration-services\/?referralCode=00C42EE09B35CC84BF93\" type=\"link\" id=\"https:\/\/www.udemy.com\/course\/data-integration-with-ssis-sql-server-integration-services\/?referralCode=00C42EE09B35CC84BF93\" target=\"_blank\" rel=\"sponsored nofollow noopener\">About SSIS variables, configurations and SSIS deployments<\/a><\/strong><\/li>\n\n\n\n<li><strong>SSIS Variables lecture &#8211; part 1<\/strong><\/li>\n\n\n\n<li><strong>SSIS Variables lecture &#8211; part 2<\/strong><\/li>\n\n\n\n<li>Quiz on Building SSIS variables<\/li>\n\n\n\n<li><strong>How to update Visual Studio and the SSIS Projects extension?<\/strong><\/li>\n\n\n\n<li><strong>Create SSIS configurations and deploy packages to SQL Server<\/strong><\/li>\n\n\n\n<li><strong>Create and manage different environments using SSIS Catalog<\/strong><\/li>\n\n\n\n<li>Quiz on SSIS variables and configuration<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-7-data-transformations-in-our-sql-server-integration-services-course\"><span class=\"ez-toc-section\" id=\"7-data-transformations-in-our-sql-server-integration-services-course\"><\/span>7. Data transformations in our SQL Server Integration Services Course<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong><a href=\"https:\/\/www.udemy.com\/course\/data-integration-with-ssis-sql-server-integration-services\/?referralCode=00C42EE09B35CC84BF93\" type=\"link\" id=\"https:\/\/www.udemy.com\/course\/data-integration-with-ssis-sql-server-integration-services\/?referralCode=00C42EE09B35CC84BF93\" target=\"_blank\" rel=\"sponsored nofollow noopener\">Data transformations introduction video<\/a><\/strong><\/li>\n\n\n\n<li><strong>Group multiple tables with the SSIS Merge JOIN component<\/strong><\/li>\n\n\n\n<li><strong>Group multiple tables with SSIS Union All<\/strong><\/li>\n\n\n\n<li>Quiz about transformation concepts<\/li>\n\n\n\n<li><a href=\"https:\/\/expert-only.com\/en\/ssis\/pivot-rows-to-columns-with-ssis\/\"><strong>Use the SSIS PIVOT to transform rows to columns<\/strong><\/a><\/li>\n\n\n\n<li><strong><a href=\"https:\/\/expert-only.com\/en\/ssis\/transform-columns-into-rows-with-ssis\/\">Transform columns into rows using SSIS UNPIVOT<\/a><\/strong><\/li>\n\n\n\n<li>Quiz about PIVOT and UNPIVOT operations in SSIS<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-8-zip-and-unzip-files-and-folders-with-ssis\"><span class=\"ez-toc-section\" id=\"8-zip-and-unzip-files-and-folders-with-ssis\"><\/span>8. ZIP and Unzip files and folders with SSIS<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>In this Integration Services training, you&#8217;ll also learn in a very practical way how to compress into archives, and extract files and folders from compressed files using SSIS without using any third-party software or licence.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong><a href=\"https:\/\/www.udemy.com\/course\/data-integration-with-ssis-sql-server-integration-services\/?referralCode=00C42EE09B35CC84BF93\" type=\"link\" id=\"https:\/\/www.udemy.com\/course\/data-integration-with-ssis-sql-server-integration-services\/?referralCode=00C42EE09B35CC84BF93\" rel=\"sponsored nofollow noopener\">About Zipping and Unzipping using SSIS packages<\/a><\/strong><\/li>\n\n\n\n<li>Download, Install and test the Zipping Software<\/li>\n\n\n\n<li>Zip files and folders into compressed archives<\/li>\n\n\n\n<li>Unzip documents to extract files and folders<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-9-full-end-to-end-bi-project-with-ssis-using-real-life-data\"><span class=\"ez-toc-section\" id=\"9-full-end-to-end-bi-project-with-ssis-using-real-life-data\"><\/span>9. Full end-to-end BI project with SSIS using real-life data<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong><a href=\"https:\/\/www.udemy.com\/course\/data-integration-with-ssis-sql-server-integration-services\/?referralCode=00C42EE09B35CC84BF93\" type=\"link\" id=\"https:\/\/www.udemy.com\/course\/data-integration-with-ssis-sql-server-integration-services\/?referralCode=00C42EE09B35CC84BF93\" target=\"_blank\" rel=\"sponsored nofollow noopener\">The end to end BI Project Presentation<\/a><\/strong><\/li>\n\n\n\n<li>Step 1: Create the ODS and the DWH databases<\/li>\n\n\n\n<li>Step 2: Create the ODS tables and load all the static dimensions<\/li>\n\n\n\n<li>Step 3: Load the Fuel Prices in the ODS tables<\/li>\n\n\n\n<li>Step 3 solution\n<ul class=\"wp-block-list\">\n<li>Part 1: Solution, Package and flat file connection<\/li>\n\n\n\n<li>Part 2: Sequence, Loop and Data Flow<\/li>\n\n\n\n<li>Part 3: Duplicate Work for Fuel Prices Without Taxes<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Step 4: Load Exchange Rates in the ODS<\/li>\n\n\n\n<li>About the DWH Database Structure<\/li>\n\n\n\n<li>Step 5: Create the DWH tables<\/li>\n\n\n\n<li>Step 6: Load the DWH Dimension tables using an SSIS package\n<ul class=\"wp-block-list\">\n<li>Part 1: Create DWH Time dimension data flow<\/li>\n\n\n\n<li>Part 2: Create DWH Currency and Country dimension data flows<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Step 7: Develop Fact Fuel Prices DWH Package<\/li>\n\n\n\n<li>Step 8: Develop Exchange Rates DWH Package<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-10-training-bonuses-ssas-tabular-and-power-bi\"><span class=\"ez-toc-section\" id=\"10-training-bonuses-ssas-tabular-and-power-bi\"><\/span>10. Training bonuses: SSAS Tabular and Power BI<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.udemy.com\/course\/data-integration-with-ssis-sql-server-integration-services\/?referralCode=00C42EE09B35CC84BF93\" type=\"link\" id=\"https:\/\/www.udemy.com\/course\/data-integration-with-ssis-sql-server-integration-services\/?referralCode=00C42EE09B35CC84BF93\" target=\"_blank\" rel=\"sponsored nofollow noopener\"><strong>Install Analysis Services 2022 on Windows<\/strong><\/a><\/li>\n\n\n\n<li>Install Analysis Services Projects on Visual Studio 2022<\/li>\n\n\n\n<li><strong>Create the SSAS Tabular model, Import DWH tables and create relationships<\/strong><\/li>\n\n\n\n<li>Create DAX Measures and Hierarchies<\/li>\n\n\n\n<li><strong>Enrich Exchange Rates and Analyse the DWH data in Excel<\/strong><\/li>\n\n\n\n<li>Deploy the Tabular Model or Import it using XMLA<\/li>\n\n\n\n<li>Fine Tuning the Tabular Model<\/li>\n\n\n\n<li>Download and Install Power BI Desktop<\/li>\n\n\n\n<li><strong>Create a Power BI Report with Graphs<\/strong><\/li>\n<\/ol>\n\n\n\n<p>In the last 2 lectures, you&#8217;ll learn 10 tips based on real BI projects from an experienced BI and EPM Engineer and Consultant.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong><a href=\"https:\/\/www.udemy.com\/course\/data-integration-with-ssis-sql-server-integration-services\/?referralCode=00C42EE09B35CC84BF93\" type=\"link\" id=\"https:\/\/www.udemy.com\/course\/data-integration-with-ssis-sql-server-integration-services\/?referralCode=00C42EE09B35CC84BF93\" rel=\"sponsored nofollow noopener\">10 Expert SSIS Tips for Successful BI Projects<\/a><\/strong><\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-a-final-word-on-our-sql-server-integration-services-course\">A final word on our SQL Server Integration Services Course<\/h3>\n\n\n\n<p>So, in conclusion to this SQL Server Integration Services course, it is a data integration tool that can be used to load data between heterogeneous systems. It can also extract, transform and load data from various sources, and perform tasks such as backing up data and archiving logs, amongst many others.<\/p>\n\n\n\n<p>This video training and different sections provide a practical approach to learning SSIS, with examples and step-by-step instructions for setting up the development environment, creating and manipulating packages, and developing <a href=\"https:\/\/en.wikipedia.org\/wiki\/SQL_Server_Integration_Services\" target=\"_blank\" rel=\"noreferrer noopener\">advanced SSIS<\/a> projects.<\/p>\n\n\n\n<p class=\"has-text-align-center\"><strong><a href=\"https:\/\/www.udemy.com\/course\/data-integration-with-ssis-sql-server-integration-services\/?referralCode=00C42EE09B35CC84BF93\" target=\"_blank\" rel=\"sponsored nofollow noopener\">Enrol today to learn Data Integration with SSIS (SQL Server Integration Services)<\/a><\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/www.udemy.com\/course\/data-integration-with-ssis-sql-server-integration-services\/?referralCode=00C42EE09B35CC84BF93\" target=\"_blank\" rel=\"sponsored nofollow noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"422\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2024\/02\/ssis-course-image_422.jpg\" alt=\"Learn ETL and data integration with SSIS on Udemy\" class=\"wp-image-29765\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2024\/02\/ssis-course-image_422.jpg 750w, https:\/\/expert-only.com\/wp-content\/uploads\/2024\/02\/ssis-course-image_422-300x169.jpg 300w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/a><\/figure>\n<\/div>\n\n\n<p>This SSIS online training covers a wide range of topics, including importing and exporting data from flat files, Excel files and XML documents, and using SSIS for data aggregation and merging. But also how to build a tabular model based on a data warehouse project with real-life data.<\/p>\n\n\n\n<p>These various lectures are aimed at both beginners and experienced IT professionals who want to improve their BI skills using the Microsoft BI stack.<\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Learn SQL Server Integration Services and Microsoft BI development of packages with our online SSIS Course. Enrol in our SQL Server Integration Services Course to master data integration and ETL using Microsoft Business Intelligence tools. And note that this <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/en\/ssis-online-training\/\" title=\"SQL Server Integration Services Course (SSIS)\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":5532,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-13063","page","type-page","status-publish","has-post-thumbnail"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL Server Integration Services Course (SSIS) - Microsoft BI<\/title>\n<meta name=\"description\" content=\"SQL Server Integration Services course with online lectures and step by step exercises to learn MS BI and Data Integration to master SSIS.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/en\/ssis-online-training\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server Integration Services Course (SSIS)\" \/>\n<meta property=\"og:description\" content=\"SQL Server Integration Services course with online lectures and step by step exercises to learn MS BI and Data Integration to master SSIS.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/en\/ssis-online-training\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL and IT Tutorials\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:modified_time\" content=\"2026-05-10T10:55:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/02\/technology-1283624_1920.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/expert-only.com\\\/en\\\/ssis-online-training\\\/\",\"url\":\"https:\\\/\\\/expert-only.com\\\/en\\\/ssis-online-training\\\/\",\"name\":\"SQL Server Integration Services Course (SSIS) - Microsoft BI\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/expert-only.com\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/expert-only.com\\\/en\\\/ssis-online-training\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/expert-only.com\\\/en\\\/ssis-online-training\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/expert-only.com\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/technology-1283624_1920.jpg\",\"datePublished\":\"2017-08-26T17:32:31+00:00\",\"dateModified\":\"2026-05-10T10:55:46+00:00\",\"description\":\"SQL Server Integration Services course with online lectures and step by step exercises to learn MS BI and Data Integration to master SSIS.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/expert-only.com\\\/en\\\/ssis-online-training\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/expert-only.com\\\/en\\\/ssis-online-training\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/expert-only.com\\\/en\\\/ssis-online-training\\\/#primaryimage\",\"url\":\"https:\\\/\\\/expert-only.com\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/technology-1283624_1920.jpg\",\"contentUrl\":\"https:\\\/\\\/expert-only.com\\\/wp-content\\\/uploads\\\/2022\\\/02\\\/technology-1283624_1920.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/expert-only.com\\\/en\\\/ssis-online-training\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"en\",\"item\":\"https:\\\/\\\/expert-only.com\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server Integration Services Course (SSIS)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/expert-only.com\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/expert-only.com\\\/en\\\/\",\"name\":\"SQL Server and Data Courses\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/expert-only.com\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/expert-only.com\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/expert-only.com\\\/en\\\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\\\/\\\/expert-only.com\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/expert-only.com\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/expert-only.com\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\\\/\\\/expert-only.com\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\\\/\\\/expert-only.com\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/ExpertOnlyCom\\\/\",\"https:\\\/\\\/x.com\\\/expert_only\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCMS5sR_FwAetB0FmciNvUaA\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server Integration Services Course (SSIS) - Microsoft BI","description":"SQL Server Integration Services course with online lectures and step by step exercises to learn MS BI and Data Integration to master SSIS.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/expert-only.com\/en\/ssis-online-training\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server Integration Services Course (SSIS)","og_description":"SQL Server Integration Services course with online lectures and step by step exercises to learn MS BI and Data Integration to master SSIS.","og_url":"https:\/\/expert-only.com\/en\/ssis-online-training\/","og_site_name":"SQL and IT Tutorials","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_modified_time":"2026-05-10T10:55:46+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/02\/technology-1283624_1920.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_site":"@expert_only","twitter_misc":{"Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/expert-only.com\/en\/ssis-online-training\/","url":"https:\/\/expert-only.com\/en\/ssis-online-training\/","name":"SQL Server Integration Services Course (SSIS) - Microsoft BI","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/en\/ssis-online-training\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/en\/ssis-online-training\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/02\/technology-1283624_1920.jpg","datePublished":"2017-08-26T17:32:31+00:00","dateModified":"2026-05-10T10:55:46+00:00","description":"SQL Server Integration Services course with online lectures and step by step exercises to learn MS BI and Data Integration to master SSIS.","breadcrumb":{"@id":"https:\/\/expert-only.com\/en\/ssis-online-training\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/en\/ssis-online-training\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/ssis-online-training\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/02\/technology-1283624_1920.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/02\/technology-1283624_1920.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/en\/ssis-online-training\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"en","item":"https:\/\/expert-only.com\/en\/"},{"@type":"ListItem","position":2,"name":"SQL Server Integration Services Course (SSIS)"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/en\/#website","url":"https:\/\/expert-only.com\/en\/","name":"SQL Server and Data Courses","description":"","publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/en\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/pages\/13063","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/comments?post=13063"}],"version-history":[{"count":48,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/pages\/13063\/revisions"}],"predecessor-version":[{"id":31178,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/pages\/13063\/revisions\/31178"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media\/5532"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media?parent=13063"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}