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

The error seems to suggest that either there is an ACL on the DSO dll file
which is preventing the account from creating the object or DSO is not
installed on the machine where the package is being executed on. This can be
quite easy for SQL Agent to do, i.e. to run the package on a machine where
DSO is not installed. First verify that DSO is indeed on the machinen where
SQL Agent is attempting to run the package and if that isn't the problem,
look to see if the is an ACL on the dlls themselves.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Paul" <Paul (AT) discussions (DOT) microsoft.com> wrote