SQL Server Performance

Connecting SQL 2000 cubes with SSIS

Discussion in 'SQL Server 2005 Integration Services' started by mutrejahema, Jul 2, 2009.

  1. mutrejahema New Member

    Hi,

    Using the 'Analysis Services Processing Task' in SSIS in 2005, we are trying to connect to an SQL Server 2000 Analysis Server cubes. We are able to successfully create an Analysis Services connection, but when we try to configure the task and specify the connection created ablove, it gives the following error:

    TITLE: Analysis Services Processing Task
    ------------------------------

    A connection cannot be made. Ensure that the server is running.

    ------------------------------
    BUTTONS:

    OK
    ------------------------------

    Is it possible to connect from SSIS Analysis Services task to SQL Server 2000 Analysis Services?
    If so, are there any explicit settings that need to be done.

    Any help is appreciated.

  2. MohammedU New Member

Share This Page