Introduction-Extract, Transform and load data using SQL Server Integration Services (SSIS)
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
Смотрите видео Introduction-Extract, Transform and load data using SQL Server Integration Services (SSIS) онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь goshedy 23 Декабрь 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 13,108 раз и оно понравилось 126 людям.