DTS Information Model

Data Transformation Services (DTS) uses the DTS Information Model to persist data transformation meta data in Microsoft® SQL Server™ 2000 Meta Data Services. The DTS Information Model is based on the Transformations package of the Open Information Model (OIM).

The DTS Information Model describes:

• The data transformations and how they are grouped into larger execution units.
  
  
• The types of data accessed.

Specifically, the DTS Information Model allows:

• The storage of data transformation meta data in one well-defined location. Storing this information in Meta Data Services allows existing transformations to be reused when a data warehouse or data mart is being rebuilt.
  
  
• The sharing of data transformation information across multiple tools. This allows the use of tools from different vendors during the building and maintenance of data warehouses.

For more information, search under Meta Data Services at Microsoft Web site.

Upgrading Meta Data Services Information Models

When you upgrade to SQL Server 2000, you must also upgrade the Meta Data Services Information Models in order to save and retrieve DTS package versions to and from Meta Data Services. Otherwise, you will receive an error when you save to Meta Data Services.

Upgrading the information models modifies the Meta Data Services table structure to support additional functionality and features provided by SQL Server 2000 Meta Data Services. In an upgrade, existing repository data is preserved in the new table structure.

Before you upgrade the information models, install SQL Server 2000. SQL Server 2000 contains the most recent DLL and EXE versions of Insrepim, the model installation program.

To upgrade information models, you need the following:

• The SQL Server 2000 CD or an equivalent installation directory that contains the information models required by DTS. To locate the information models, search for *.rdm files on the SQL Server 2000 CD.
  
  
• Insrepim.exe, the model installation program that creates or updates the Meta Data Services tables and installs information models. When you upgrade to SQL Server 2000, this program is installed on your computer.
  
  
• A batch file to install the models. This file must reside in the directory that contains the insrepim.exe file. After you create the batch file, run it from a command prompt.

Creating an Installation Batch File

Replace the <placeholder> values in the following batch file text with real values that apply to your system. For example:

• <path> must be the path to the CD or to the installation directory.
  
  
• <servername> must the name of the SQL Server.
  
  
• <sa> must be the SQL Server system administrator login. If you are using Windows Authentication, do not specify this parameter.
  
  
• <password> must be the SQL Server system administrator password. If you are using Windows Authentication, do not specify this parameter.

Information models must be installed in the exact order shown below. The lines headed with REM are comments:

REM  Usage:  InsRepIM.exe 
REM  Syntax:  /f[Model File] /r[Repository connect string] /u[User] /p[Password]
REM  
insrepim.exe /f<path>\uml.rdm /rserver=<servername>;database=msdb /u<sa> /p<password>
insrepim.exe /f<path>\umx.rdm /rserver=<servername>;database=msdb /u<sa> /p<password>
insrepim.exe /f<path>\gen.rdm /rserver=<servername>;database=msdb /u<sa> /p<password>
insrepim.exe /f<path>\dtm.rdm /rserver=<servername>;database=msdb /u<sa> /p<password>
insrepim.exe /f<path>\dbm.rdm /rserver=<servername>;database=msdb /u<sa> /p<password>
insrepim.exe /f<path>\tfm.rdm /rserver=<servername>;database=msdb /u<sa> /p<password>
insrepim.exe /f<path>\dts.rdm /rserver=<servername>;database=msdb /u<sa> /p<password>
insrepim.exe /f<path>\sql.rdm /rserver=<servername>;database=msdb /u<sa> /p<password>
insrepim.exe /f<path>\db2.rdm /rserver=<servername>;database=msdb /u<sa> /p<password>
insrepim.exe /f<path>\ocl.rdm /rserver=<servername>;database=msdb /u<sa> /p<password>
insrepim.exe /f<path>\ifx.rdm /rserver=<servername>;database=msdb /u<sa> /p<password>
insrepim.exe /f<path>\olp.rdm /rserver=<servername>;database=msdb /u<sa> /p<password>
insrepim.exe /f<path>\mds.rdm /rserver=<servername>;database=msdb /u<sa> /p<password>
insrepim.exe /f<path>\sim.rdm /rserver=<servername>;database=msdb /u<sa> /p<password>

See Also

OIM in Meta Data Services