Essential Microsoft Operations Manager

Data Transformation Service

DTS is a SQL Server 2000 tool that takes data from a source database, manipulates it, and inserts it into a destination database. When MOM Reporting is installed, a scheduled task is created on the reporting server that calls a DTS package-creating executable. The executable, located in <installdrive> \Program Files\Microsoft System Center Reporting\Reporting, is named MOM.Datawarehousing.DTSPackageGenerator.exe. This DTS package then takes operational data, transforms it into the correct format for the System Center Reporting database, and inserts the data into that database.

All the configuration options are set in this command-line call of the scheduled task:

Figure 7-21. Successful restore of the master database

    MOM.Datawarehousing.DTSPackageGenerator.exe /silent /srcserver:homesqlserver /srcdb:
    OnePoint /dwserver:HOMESQLSERVER /dwdb:SystemCenterReporting /product:"Microsoft
    Operations Manager"

There is nothing else that you should need to do. However, since DTS touches the OnePoint database on a daily and on-demand basis, you should be familiar with it. There may come a time when you want to trigger a data transfer, such as before performing maintenance on the OnePoint database server that requires an outage. You want to make sure that the most current data has been copied to the data warehouse before proceeding.

By default, the scheduled task (see ...