SSIS 2012 - Analysis Services Processing task - Connection cannot be made by Trevor Howe

Active

Type:	Bug
ID:	778516
Opened:	2/4/2013 10:10:12 PM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

Hi
We are busy migrating our packages from SQL 2008 R2 to SQL 2012. Some of our packages process Analysis Services objects as part of the package flow. I have set the connection to the correctly to the 2012 Analysis Services server and Test Connection works fine. When I open up the AS task in the control flow of the package and use the above mentioned connection it give me the error: "A connection cannot be made. Ensure that the server is running". I can connect and browse the cube in Management studio. I am using the Native OLEDB\Microsoft OLE DB Provider for Analysis Services 11.0. Here is the connection string:
Data Source=<Server>\<Instance>;Initial Catalog=<cube>;Provider=MSOLAP.5;Integrated Security=SSPI;Location=<Server>\<Instance>;

Details (expand)

English

SQL Server 2012 - Enterprise Edition

Integration Services (DTS)

Windows 7 Professional

English

1. Create Package
2. Add Connection to Analysis Services in Connection Manager pane.
3. Test Connection - test successful
4. Add AS Processing task in Control Flow
5. Edit above task to use connection created in 2 above
6. Error happens here

Error message

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

0 attachments

Posted by kameshperi on 4/4/2013 at 5:21 PM

I have this issue while creating a connection to ssas tabular model (11.03) from SSIS analysis services processing task(11.0). Not sure if it is a bug. Earlier i was able create a connection and see objects when connecting to a ssas tabular 11.0 model.

Posted by Trevor Howe on 2/6/2013 at 1:52 AM

Hi

I have managed to solve this issue. Not sure if it is a workaround or whether this is the proper way to do it. To solve the above problem you have to delete the connection to the cube in the Connection Mangers. Then open up the Analysis Services Processing task and recreate the connection (Click New and go through the usual connection stuff). Once this has been done you should be able to see the AS objects that you want to process. It looks like even though you recreate the connection information for the 2012 environment on the migrated package, something about the connection manager object is incompatible with the new package. Deleting this connection and recreating it clears that up.

Microsoft