When you attempt to install the DTS (Data Transformation Services) redistributable package for Microsoft SQL Server 2005 on a Windows 2000 Advanced Server SP4 computer, the installation fails with:
Impossible to register the module <Drive_Letter>:\Program Files\Microsoft SQL Server\80 \Tools\Binn\dtsui.DLL. HRESULT -2147024770.
NOTE: -2147024770 means The specified module could not be found.
This behavior will occur unless MDAC 2.8 is installed, as earlier versions of MDAC do not contains the required Sqlunirl.dll file.
To workaround this behavior, install or upgrade to MDAC 2.8 or later.