Introduction-Extract, Transform and load data using SQL Server Integration Services (SSIS)

Published: 23 December 2022
on channel: goshedy
13,108
126

Welcome to my you-tube channel, Learn how to Extract, Transform and load data using Microsoft SQL Server Integration Services (SSIS) (Which is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks).
In this project we are going to Extract data from a flat file, make some necessary Transformation and Load the data into a Destination. This project is broken down into the 9 (nine) lessons, This part of the project will help you understand what the project is all about and also prepare you for the upcoming lessons .
At the end of this Tutorial, you’ll learn how to:
Created a new SSIS project.
Configured the connection managers for the package to connect to the source and destination data.
Added a data flow that takes the data from a flat file source, performs the necessary Lookup transformations on the data, and configures the data for the destination.
Finally, Load the data into a Destination.

Prerequisites
SQL Server Management Studio (SSMS)
Download here: https://learn.microsoft.com/en-us/sql...

Visual Studio Installer
Visual Studio Community (Visual Studio)
SQL Server Data Tools (SSDT) for Visual Studio
Download here:https://visualstudio.microsoft.com/do...

Flat File (SampleCurrencyData.txt)
Download here: https://github.com/sheddyranking/Yout...

AdventureWorksDW2012 sample database
Download here: https://learn.microsoft.com/en-us/sql...


Connect with me on LinkedIn
  / sheddyranking  

follow me on   / goshedy  
  / goshedy  
  / goshedys  

Video Chapter:
0:00 Introduction- Extract, Transform and load data using Microsoft SQL Server Integration Services (SSIS)
03:29 - Installing SSMS (SQL Server Management Studio)
04:02 - Installing Visual Studio
05:43 - Installing SQL Server Data Tools
06:43 - Installing Visual Studio Community
07:30 - Installing SQL Server Integration Services(SSIS), SQL Server Analytical Services(SSAS), SQL Server Reporting Services(SSRS)

#ssis, #datamigration #ETL #ssms #visualstudio2022


Watch video Introduction-Extract, Transform and load data using SQL Server Integration Services (SSIS) online without registration, duration hours minute second in high quality. This video was added by user goshedy 23 December 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 13,108 once and liked it 126 people.