| Feature | SSIS (SQL Server Integration Services) – ETL Tool | SSAS (SQL Server Analysis Services) – Data Analysis Tool | SSRS (SQL Server Reporting Services) – Reporting Tool |
|---|---|---|---|
| Type | ETL tool | Data analysis / OLAP | Reporting tool |
| Main Role | Data movement & transformation | Data modeling and fast querying | Generating and managing reports |
| Focus | Integration | Analysis | Presentation |
| Data Storage | No | Yes (cubes/tabular models) | No |
| Output | Data in tables | Aggregated analytical data | Reports (PDF, Excel, etc.) |
| End Users | Developers, DBAs | Data analysts, decision makers | Business users, executives |