Tuesday, March 20, 2012

Check if cube exists

How can I check whether a cube exists and make the control flow dependend on that?
Thanks for help!!

By using AMO in a script task

HTH
Ovidiu

|||Could you give me a small example?
There is only little information available in the SQL Server help.
The help for AMO shows me, there should be aMicrosoft.AnalysisServices Namespace. However, when I open the Script designer, it know nothing about this namespace. I can't even find this namespace on msn.
|||Note: I found the Microsoft.AnalysisServices.dll, but how can I reference this assembly in SSIS?
|||I finally found the "References" node in the object explorer (seems kind of stupid I didn't saw it..)

No comments:

Post a Comment