Performance Comparison of ETL Methods

SSIS is a very powerful ETL tool. Given the fact that it is used to extract and load data from different data sources it has a myriad of options available to achieve the task. Developers are often confused about the difference between each task and how much of an impact they have on the overall load times . In this video will demonstrate each of the different options available and the performance implications they have with regard to data load times on the database server specifically Microsoft SQL server. We try to cover this data sources in a way that makes it clear that they are not necessarily interchangeable and work differently based on different scenarios . By understanding the advantages and disadvantages of each of these tasks and methods we hope that user would be able to make a more informed decision on how to load data using SSIS .

Need more information?

Jayanth is a Microsoft SQL Server trainer / consultant with over 15 years experience. He has worked with companies like Microsoft, IBM, HCL , Wipro , WellFargo , Zeomega and many more. He is based out of Bangalore and a very active member of the SQL Server Community.

In this channel he covers complex topics related MS SQL Server , PowerBI , Azure , AWS , Powershell, SSIS , SSAS , SSRS , Machine Learning , AI , etc

You can also reach Jayanth via his LinkedIn profile below