none
Best way to deploy SSAS & Set Cube datasource dynamically via SSIS Package RRS feed

  • Question

  • Hello,

    we are trying to find the best way for deployment process of a SSAS cube, actually we've created an ssis project that fills the datawarehouse and at the end process the cube.

    but the problem is that there's we can not seem to find a way to change the datasource for the ssas project so that it can points on the datawarehouse database in the other servers, at the moment of deploying ssis package from an environnement to an other.

    Should we always open the solution in visual studio, change the datasource for the cube and after that deploy? because it doesn't make much sence.

    Monday, January 20, 2020 8:09 AM

Answers

  • Hi Kabarousse,

    Thanks for your question.

    >>Should we always open the solution in visual studio, change the datasource for the cube and after that >>deploy? because it doesn't make much sence.

    No, you don't have to. You can change the data source by using SSMS on server side , but you need to make sure the data schema of  original data source is the same as the one of the data source you're referring to. 

    Best Regards,

    Will


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Tuesday, January 21, 2020 2:41 AM

All replies

  • Hi Kabarousse,

    Thanks for your question.

    >>Should we always open the solution in visual studio, change the datasource for the cube and after that >>deploy? because it doesn't make much sence.

    No, you don't have to. You can change the data source by using SSMS on server side , but you need to make sure the data schema of  original data source is the same as the one of the data source you're referring to. 

    Best Regards,

    Will


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Tuesday, January 21, 2020 2:41 AM
  • Thank you so much

    SKABAROUSSE

    Tuesday, January 21, 2020 8:02 AM