Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2005

    Unanswered: 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?
    Last edited by bredins; 02-21-05 at 12:48.

  2. #2
    Join Date
    Jan 2005
    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

  3. #3
    Join Date
    Feb 2005
    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts