O'Reilly logo

Essential Microsoft Operations Manager by Chris Fox

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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:

Successful restore of the master database

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required