none
Analysis Services Processing Task - Variable RRS feed

  • Question

  • Hi, 

    I am trying to processing cube in SSIS using the Analysis Services Processing Task.

    I have 3 different cubes and only 1 of them need to be processed as per the expression in connection manager.

    My connection manager expression - if the Process is Daily process cube - "Tools", if the Process is Weekly then process cube "Even" and if Monthly the process the cube  "Odd".

    Problem : The Analysis Services Processing Task is not using the updated connection manager, I created the package with Tools as initial connection, though i change the variable to Weekly/Even it processes Tools cube.

    I also checked if the connection manager was getting updated and it is. its just that the  Analysis Services Processing Task is not picking up from the updated connection manager.

    Any help or suggestions will be appreciated. Thank You

    Tuesday, November 12, 2019 10:07 PM

All replies

  • Hi KomalSingh12,

    Could you please share the screenshots of your Analysis Services Processing Task and connection manager expression?

    Best Regards,

    Mona


    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

    Wednesday, November 13, 2019 2:29 AM