Error_mod_not_found in legacy DTS packages
Posted on 2011-03-03
I get the following error when clicking the ellipsis to look at a specific lookup in a legacy dts package.
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.
I have recently migrated from Windows XP to Win 7 , I have installed SSMS and done all the steps for backward compatibility for DTS 2000 packages which includes adding DTS 2000 components and backward compatibility for Sql Server 2005 and moving the DLLs per instructions on the MSDN website.
I was able to edit the lookups on the DTS packages on my Windows XP machine.
Any help will be much appreciated!