By learn SSIS channel we will learn how to use SSIS for ETL purpose. SQL Server Integration Services is an ETL tool provided by Microsoft for ETL purpose.
ETL (Extract, Transform and Load) is a process in data warehousing responsible for pulling data out of the source systems and placing it into a data warehouse. If we want to load data from flat file or from excel file to SQL Server then we need some ETL tool like SSIS for this purpose. This channel Learn SSIS is aimed at providing professionals with knowledge on SQL Server Integration Services. If you regularly see videos in this channel, you will be able to
• Design and Understand the SSIS Solutions • Import and Export Data from and to different Sources • Create, manage and maintain SSIS Packages • Import and Export Data from and to different Sources using SSIS • Use different Transformations to change the data on the fly
