In this master thesis the main focus will be the analysis of Microsoft's SQL Server 2012 SSIS ETL tool. Microsoft Integration Service is Microsoft's a platform which provides business solutions for data integration an data transformation processes into their business envieroment. Microsoft SSIS also allows us the solving of complex business tasks like data extraction and copying data from different sources, the process of building data warehouses, their maintenance and data loading processes as well as various data operations like data cleaning and filtering, data mining, data adjustment, analysis and storage. The SSIS platform is a part of Microsofts wide selection of business inteligence tools, and although it has a strong competition found in IBM, Oracle and Informatica PowerCenter it has earned his place on top of the list. While working and analyzing the characteristics of the SSIS tool which comes as a part of the Microsoft SQL Server 2012 Business intelligence, the facts which will be told are going to be shown and explained with proper examples. The examples will be demonstrated using the SQL Server Data Tool and SQL Server Management Studio, a tool which is used for database management. ETL tools are a must have while working with data warehouses. Their usage can be found while performing data extractions, data transformations and data loading processes from one or multiple source databases into our data warehouse which is meant for a specific business purpose. In the introduction part of this master thesis, the main parts of the ETL processes will be explained. The other part is going to be about the three main ETL processes, extracting, transforming and loading of data. All steps will be shown by using only the Microsoft SSIS platform for data integration. A look into the many different tools for data manipulations will be given as well.