I have an ActiveX VB script in a DTS package that simply connects to a server
and populates a table with a list of all the Analysis Services databases on
that server.

When I execute this package from my desktop it works fine.

When I execute it through the Agent I get the error
Error Description: Object required: 'dsoServer'

Which is happening on this line of script
dsoServer.Connect (ServerName)

This happens to be the first line of script that actually tries to use the
DSO object, so I’m guessing that the account that the Agent runs under can’t
access the object model for DSO. However, this account is in the OLAP admin
group. What else does this account need to be able to see/use the DSO object?

Thanks in advance for any help!
Paul