Forum Discussion

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

  • olafhelper's avatar
    olafhelper
    Bronze 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.'s avatar
      Bakhtawar A.
      Copper Contributor
      yes after ETL process and load all the data then how to use that same data for analytical purpose? like in SSAS?
      • olafhelper's avatar
        olafhelper
        Bronze Contributor
        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.

Resources