Is it possible to connect from the SSIS Analysis Services task to SQL Server 2000 Analysis Services?
Using the Analysis Services Processing Task in SSIS 2005, we are trying to connect to SQL Server 2000 Analysis Server cubes. While we are able to successfully create an Analysis Services connection, when we try to configure the task and specify the connection created above, we receive 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 the SSIS Analysis Services task to SQL Server 2000 Analysis Services?
If so, are there any explicit settings that need to be done?
Software/Hardware used:
Software/Hardware used:
ASKED:
July 6, 2009 4:41 PM
UPDATED:
July 6, 2009 5:15 PM
RELATED QUESTIONS
- SSIS package using dynamic configurations
- a question about IMPORT/EXPORT from the SQL 2005 Migration
- The SQL Server Analysis Services (MSSQLSERVER) service terminated unexpectedly.
- Merge two companies into one network
- SSIS 2008 R2 performance and Windows Server 2008 R2 with a clustered SQL instance is slower than when connecting to a non-clustered instance?
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
