Microsoft KB Archive/904796

= You cannot run or schedule various packages that require SQL Server 2000 Meta Data Services files after you upgrade to SQL Server 2005 =

Article ID: 904796

Article Last Modified on 3/11/2006

-

APPLIES TO


 * Microsoft SQL Server 2005 Developer Edition
 * Microsoft SQL Server 2005 Enterprise Edition
 * Microsoft SQL Server 2005 Express Edition
 * Microsoft SQL Server 2005 Standard Edition
 * Microsoft SQL Server 2005 Workgroup Edition

-





SYMPTOMS
Consider the following scenario. On a computer that is running Microsoft SQL Server 2005, you try to perform one of the following tasks:
 * You run or schedule a SQL Server 2000 Meta Data Services package.
 * You run or schedule a SQL Server 2000 Data Transformation Services (DTS) package that uses the Execute Package task to run a SQL Server 2000 Meta Data Services package.
 * You run or schedule a SQL Server 2005 Integration Services (SSIS) package that uses the Execute DTS 2000 Package task to run a SQL Server 2000 Meta Data Services package.
 * You run or schedule an SSIS package that uses the Execute DTS 2000 Package task to run a SQL Server 2000 DTS package that uses the Execute Package task to run a SQL Server 2000 Meta Data Services package.

When you try to perform task 1 or task 2, you receive the following error message:

The Microsoft Repository COM Server has not been registered on this system.

When you try to perform task 3 or task 4, you receive the following COMException exception error message:

SSIS package starting.

Error: 0x0 at : System.Runtime.InteropServices.COMException (0x80040427): Execution was canceled by user.

at DTS.PackageClass.Execute

at Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.Exec80PackageTask.ExecuteThread Task failed: Warning: 0x80019002

at : The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. SSIS package finished: Failure.

Note The  is a placeholder for the name of the package that you are trying to run.



CAUSE
The error message and COMException error message that are noted in the Symptoms section occur when SQL Server 2000 Meta Data Services files are not present.



RESOLUTION
To correct this problem, you must add or restore the SQL Server 2000 Meta Data Services files that are a component of SQL Server 2000. To do this, use one of the following methods:
 * Reinstall the SQL Server 2000 tools.
 * Copy and register the required files from a computer that has SQL Server 2000 installed, subject to appropriate licensing and distribution requirements, by following the instructions in the SQL Server 2000 Redist.txt file.

To extract DTS packages from SQL Server 2000 Meta Data Services, use the DTSRUN command (Dtsrun.exe) with the /!X option.

Note We recommend that you export the DTS packages in SQL Server 2000 Meta Data Services before you upgrade to SQL Server 2005.



MORE INFORMATION
The Meta Data Services component of SQL Server 2000 does not exist in SQL Server 2005. If you uninstall SQL Server 2000 or if you upgrade the computer from the most recent version of SQL Server 2000 to SQL Server 2005, the files that support access to SQL Server 2000 Meta Data Services will be removed.

DTS Designer and the DTSRUN command continue to support DTS packages that were saved to SQL Server 2000 Meta Data Services as long as the SQL Server 2000 Meta Data Services files are present.

SSIS supports SQL Server 2000 Meta Data Services in the SQL Server 2005 Upgrade Advisor program and in the SQL Server 2005 Package Migration Wizard. If the SQL Server 2000 Meta Data Services files are present, the Upgrade Advisor and the Package Migration Wizard can, respectively, scan and migrate the DTS packages that were saved to SQL Server 2000 Meta Data Services. If the SQL Server 2000 Meta Data Services files are not present, the Upgrade Advisor and the Package Migration Wizard can, respectively, scan and migrate only those DTS packages that were saved to SQL Server 2000 or to structured storage files.

The SSIS Execute DTS 2000 Package task cannot execute DTS packages that have been saved to SQL Server 2000 Meta Data Services. To work around this issue, follow these steps:
 * 1) Create a DTS package that uses an Execute Package task to execute the SQL Server 2000 Meta Data Services package.
 * 2) Save the DTS package that you have created to SQL Server 2000, or save the DTS package to a structured storage file.
 * 3) Execute the DTS package by using the SSIS Execute DTS 2000 Package task.



Notes  The following three files are required for basic SQL Server 2000 Meta Data Services functionality:  Repodbc.dll Dbscan.dll Reprc.rll

You must register the Repodbc.dll file and the Dbscan.dll file by using the Regsvr32.exe utility.</li> Redistributable files

The following SQL Server 2000 Meta Data Services files are redistributable: </li> Installation notes for SQL Server 2000 Meta Data Services files

Install the following SQL Server 2000 Meta Data Services files in the Program Files\Common Files\Microsoft Shared\Repository directory:  DBScan.dll</li> InsRepIM.dll</li> InsRepIM.exe</li> Msmdcxml.dll</li> Repbr.dll</li> Repbrui.dll</li> Repodbc.dll</li></ul>

Install the following SQL Server 2000 Meta Data Services files in the Program Files\Common Files\Microsoft Shared\Repository\resources\1033 directory:  Reprc.rll</li> Msmdcxml.rll</li> Msrmirc.rll</li> Repbrui.rll</li> Repbrmdc.rll</li></ul>

Install the following SQL Server 2000 Meta Data Services files in the Program Files\Common Files\Microsoft Shared\Repository\OIM\Install directory: <ul> <li>DB2.rdm</li> <li>DBM.rdm</li> <li>DTM.rdm</li> <li>DTS.rdm</li> <li>EQM.rdm</li> <li>GEN.rdm</li> <li>IFX.rdm</li> <li>MDS.rdm</li> <li>OCL.rdm</li> <li>OLP.rdm</li> <li>SIM.rdm</li> <li>SQL.rdm</li> <li>TFM.rdm</li> <li>UML.rdm</li> <li>UMX.rdm</li></ul>

The following SQL Server 2000 Meta Data Services files must be registered by using the Regsvr32.exe utility: <ul> <li>DBScan.dll</li> <li>InsRepIM.dll</li> <li>Msmdcxml.dll</li> <li>Repbr.dll</li> <li>Rpbrui.dll</li> <li>Repodbc.dll</li></ul> </li></ul>

<div class="references_section">