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 SSAS?
kindly suggest.. i want to use adventurework database
14 Replies
Hello Bakhtawar A.
if it is starting the services you should go to the Services console (services.msc) and check that both SQL Server Integration Services and SQL Server Analysis Services are in running state
then you should use SQL Server Management Studio to connect to them (aka.ms/ssms)
Open SSMS, go to File , Connect to Object Explorer and the in Server Type pick either SSIS or SSAS
Regards
Javier
- olafhelperBronze Contributor
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
- Bakhtawar A.Copper Contributoryes after ETL process and load all the data then how to use that same data for analytical purpose? like in SSAS?
- olafhelperBronze ContributorYes, creating a cube in SSAS is a good way for reporting in client apps like MS Excel, see the tutorial link I posted before.