Unable to access the Analysis Services Processing task

  • I'm an Analysis Services newbie, and I've just installed Analysis Services on my SQL Server 2000 (sp3a) Win 2000 box.

    I've applied the sp3a for analysis services and I'm now trying to add an "Analysis Services Processing task" to an existing package within DTS designer, however it doesn't appear on the task list.

    What do I need to do to get it to appear?

     

    Thanks in advance.

     

    Anto

     

  • It's not clear from your problem description whether or not you are modifying the DTS package using the client tools on the server where you installed AS2K or on another client machine.  

    I suspect that you are using SQL client tools (Enterprise Manager) from a different machine than your server and that the AS2K client has not been installed on that machine.  The Processing Task icon will only show up if the AS2K client has been installed.

  • Kelli,

    I'm using the DTS designer on the actual server, not from a client PC.

    I installed AS2K on the server that had SQL 2000(sp3a) already installed and then applied the Analysis Services pack 3A, however even with several re-boots, the AS2K task doesn't appear in the DTS designer.

     

    Anto

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply