var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Problem with scheduling an Analysis Services task
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?
Last edited by bredins; 02-21-05 at
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 using "The specified module could not be found" -2147024770 (8007007E)
I love deadlines. I like the whooshing sound they make as they fly by. Douglas Adams
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?