Forum Discussion
where should i start ssis or ssas
Hi i want to ask after installing and all .. first from where should i start.. like first i have SSIS package or SSAS paakcage? if SSIS first will be create then how i integrate that package in ...
like first i have SSIS package or SSAS paakcage?
Bakhtawar A. , your post is a bit strange, SSIS and SSAS are very different services, which can only work indirect together.
SSIS is a ETL tool = "Extract, transforming and loading" to e.g. fill a data warehouse.
SSAS is a OLAP system = "Online Analytical Process" to allow fast reporting even on big data.
Integration Services Tutorials - SQL Server Integration Services (SSIS) | Microsoft Learn
Analysis Services Tutorials | Microsoft Learn
- yes after ETL process and load all the data then how to use that same data for analytical purpose? like in SSAS?
- Yes, creating a cube in SSAS is a good way for reporting in client apps like MS Excel, see the tutorial link I posted before.
- create cube in SSAS? if we create cube in SSAS then what we do in SSIS ? we can also create cube in SSIS right ?
