none
The specified module could not be found. (ERROR_MOD_NOT_FOUND)

    Domanda

  •  

    when I click on the lookups tab with SQL Server 2005 Legacy DTS I get the following error.

     

    The specified module could not be found. (ERROR_MOD_NOT_FOUND)

    Some modules the query builder depends on could not be found. The query builder designer will not be functional.

     

     

     

    What module is this and how do I get it?

    mercoledì 23 aprile 2008 19:10

Tutte le risposte

  • I am having the same exact problem, have a call open with MS, when I hear back, I'll post the solution.
    lunedì 24 novembre 2008 21:45
  • Did you check out

      http://msdn.microsoft.com/en-us/library/ms143706(SQL.90).aspx

     

    and make sure the run-time and design-time support for DTS packages have been installed?

     

    martedì 25 novembre 2008 02:41
  • I am seeing this issue as well and no, the above link does not address the issue.

    I get the error when clicking the ellipsis to look at a specific lookup in a dts package.
    martedì 25 novembre 2008 21:55
  • Do This to resolve the issue:


    1) Install SQL 2K client
    2) SQL2K sp4
    3) Hotfix 2151

    4) SQL 2K5 client
    5) The SQL 2K DTS components for SQL 2K5

     

    • Proposto come risposta Ryan Dev mercoledì 8 aprile 2009 15:28
    mercoledì 26 novembre 2008 16:39
  • Hi,

    The last info is spot on.

    Here is complete steps I had to follow, to enable admin of DTS in SQL 2005 on x64/x86, when running on Windows 7 x64 test rig:
    1. Installed x64 SQL 2005 tools, with Integration Services for some required components.
    2. Service Packed it via Windows Update (run it twice to get followup Vista updates).
    3. Went to here: http://www.microsoft.com/downloads/details.aspx?FamilyID=536fd7d5-013f-49bc-9fc7-77dede4bb075&displaylang=en
        which seems to be the only latest versions from various MS pages that work correctly (Feature Pack for Microsoft SQL Server 2005 - December 2008 for reference):
      a) Installed x86 Microsoft SQL Server 2000 DTS Designer Components 
      b) Installed x64 Microsoft SQL Server 2005 Backward Compatibility Components
    4. Fired up tools, edited a DTS, all looked fine. Tried to 'Build Query' and got the dreaded ERROR_MOD_NOT_FOUND

    Now, at this point (with hindsight), could have jumped to step 7, but for the record I did this:

    5. Uninstalled all of that, thinking it was x64 that was limited enought to not give full DTS admin tools.
    6. Reinstalled it all again with purely x86, got exactly the same error. (Along with an error about DTS COM dll being installed as both x86 and x64)

    7. Carried on and installed SQL 2K client (x86 I think).
    8. Service packed it to 4.
    9. Looked for Hotfix, but couldn't acquire it, and it was related to an Index issue I won't walk into, so didn't bother.
    10. Retried the same 'Build Query' and it worked.
    11. Got down on the floor and prayed to the mighty Schmed.

    Hope that pain helps someone else, or even me in a year. *Waves to self in future*
    mercoledì 8 aprile 2009 15:27