Script calling AMO Server object fails

[GrandMauler]

This one is pretty staightforward:

Here's the part of the code that fails:

Dim oServer As New Microsoft.AnalysisServices.Server
oServer.Connect("MyServer")

Here's what you need to know: MyServer was removed from our company's domain and put on a separate network for security reasons.

There is a router link between the calling server and MyServer. So I can access MyServer if I fully qualify the name: MyServer.Mycompany.com

In all the the other code in my SSIS pkg, all I have to do is fully qualify the server name and provide the appropriate password.

However, that doesn't seem to be the case with the AMO object.

What should the connection string look like?

 

[GrandMauler]

I just thought of something:

Is is possible to pass an actual Connection Object from the SSIS layer down to the VB Script?

Assume the Connection Object is MSOLAP90 (in other words, an Analysis Services connnection).

Let me know what you think.