Problem with scheduling an Analysis Services task

Hi All,

I have a problem with scheduling an Analysis Services task.

When I execute the DTS package from EM, every thing works fine.

When I schedule the package from SQL Agent, I get the following error when the job executes:

Error = -2147024770 (8007007E)
Error string: The specified module could not be found.
Error source: Microsoft Data Transformation Services (DTS) Package

I am running SQL 2K SP3a with Analysis Services 2K SP3a on WIN Server 2003 Std Edition

Any ideas or suggestions?Looks like your client has modules installed that the SQL Server does not. When you run the package from SQL EM, it uses your local machine's configuration as the context. When you run from SQL Agent, it uses the SQL Server's context.

Try searching here (http://support.microsoft.com) using "The specified module could not be found" -2147024770 (8007007E)|||Hi MaxA,

Thanks for your response. When I execute the package from EM on the server itself it works fine.

Will check out the ms site now... I thought Google would pick up everything on it?