Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/249842

From BetaArchive Wiki
Knowledge Base


PRB: DTS Package Creation May Fail with "Could not create Component Categories Manager"

Article ID: 249842

Article Last Modified on 5/26/2001



APPLIES TO

  • Microsoft SQL Server 7.0 Standard Edition



This article was previously published under Q249842

SYMPTOMS

When you create a new Data Transformation Services (DTS) package on a Microsoft Windows NT 4.0 server, the following error may be reported:

Could not create Component Categories Manager

This error does not occur when creating a package on a Microsoft Windows 2000 server.

CAUSE

Comcat.dll has not been registered properly or an incorrect version of the Comcat.dll file has been installed.

There are two versions of this DLL:

  • Version 4.71: 22 KB (Correct version)
  • Version 5.00: 6 KB (Incorrect version)


WORKAROUND

First, try registering the Comcat.dll file that you currently have on your system. To do this, on the Start menu, click Run, and type regsvr32 Comcat.dll. Also register the following DTS files:

Dtspkg.dll
Dtspump.dll
Dtsffile.dll
Dtsui.dll
                    

If you continue to see the error, follow these steps to replace Comcat.dll version 5.0 with version 4.71:

  1. Unregister Comcat.dll version 5.0. To do this, on the Start menu, click Run, and type regsvr32 /u Comcat.dll.
  2. Delete or rename the incorrect Comcat.dll file, which is located in your [windir]/system[32] directory.
  3. Copy Comcat.dll version 4.71 version from the the x86\System directory of the SQL Server 7.0 CD to your [windir]/system[32] directory.
  4. Register version 4.71. To do this, on the Start menu, click Run, and type regsvr32 Comcat.dll.


Keywords: kbprb KB249842