SQL Server Integration Services (SSIS) is a SQL Server component that facilitates data extract, Consolidation, and loading (ETL). SSIS can interact with a wide range of data formats, including Excel, delimited text files, fixed-width text files, and XML. SSIS also allows you to automate the import, export and conversion of data.
In this training you will understand how to design, develop, deploy, and operate SSIS ETL solutions. By the end of this course you will have a firm understanding of SSIS concepts, and the knowledge to build high performance integration solutions and ETL packages for data warehousing. In this course, each module is reinforced with structured hands-on exercises.