Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Managing SQL Analysis Service Objects with SSIS and AMO Expand / Collapse
Author
Message
Posted Thursday, May 1, 2008 9:36 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 20, 2011 4:29 AM
Points: 4, Visits: 51
Comments posted to this topic are about the item Managing SQL Analysis Service Objects with SSIS and AMO
Post #494027
Posted Saturday, May 3, 2008 8:58 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 5, 2014 12:07 PM
Points: 7, Visits: 35
Can you use the same concept to backup an Analysis Services OLAP database and restore it to a remote server? If so please post the codes and procedures as I have tried to include this backup and restore in a SSIS package. Thanks.
Post #494656
Posted Friday, February 26, 2010 9:04 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, November 20, 2014 10:24 AM
Points: 1,865, Visits: 3,620
Thanks for the article.

I'm trying to follow the steps in the article and I'm stuck at the point where we are adding the references in the script task.

I'm using SSAS 2008, and I see a number of references starting with Microsoft.AnalysisServices, but no reference just as Microsoft.AnalysisServices, for example:

Microsoft.AnalysisServices.AdomdClient
Microsoft.AnalysisServices.AdomdServer
etc.

I also see a reference for Analysis Management Objects.

Which of these references should I pick, and how would that change the code?


__________________________________________________________________________________

Turbocharge Your Database Maintenance With Service Broker: Part 2
Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #873512
Posted Friday, February 26, 2010 9:50 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, November 20, 2014 10:24 AM
Points: 1,865, Visits: 3,620
Marios Philippopoulos (2/26/2010)
Thanks for the article.

I'm trying to follow the steps in the article and I'm stuck at the point where we are adding the references in the script task.

I'm using SSAS 2008, and I see a number of references starting with Microsoft.AnalysisServices, but no reference just as Microsoft.AnalysisServices, for example:

Microsoft.AnalysisServices.AdomdClient
Microsoft.AnalysisServices.AdomdServer
etc

I also see a reference for Analysis Management Objects.

Which of these references should I pick, and how would that change the code?


Answer to my previous post: I selected the "Analysis Management Objects" reference (version 10) and everything else was kept exactly the same as in the article.

Another question:
is it possible to have the same code in C# as well? I'm having difficulty converting between the 2 languages, I'm relatively new to this...


__________________________________________________________________________________

Turbocharge Your Database Maintenance With Service Broker: Part 2
Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #873557
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse