SQL Server Integration Services (SSIS) is a component of SQL Server which can be used to perform a wide range of Data Migration and ETL operations. SSIS is a component in MSBI process of SQL Server.
This is a platform for Integration and Workflow applications. It is known for a fast and flexible OLTP and OLAP extensions used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and multidimensional data sets.
SQL Server Reporting Services (SSRS) provides the ability to create highly formatted, print-ready and interactive reports and dashboards. SSRS offers a powerful style of reporting that graphically depicts performances measures with intuitive and interactive displays. SSRS is known for its user friendly visualization components such as gauges, sliders and maps, and KPIs that are required for any business.
SQL Server Analysis Services (SSAS) provides interactive data visualization and search-based data discovery solutions with local and geo-spatial inlligence. Paired with KPIs and indicators, SSAS offers us embedded mining and businessforecasting solutions. SSAS Online Analytical Processing (OLAP) offers Cube Design, Hosting, Deployment, Management, End User usage and enrichjed security features at granular levels.