Skip to Main Content
Essential Microsoft Operations Manager
book

Essential Microsoft Operations Manager

by Chris Fox
February 2006
Intermediate to advanced content levelIntermediate to advanced
384 pages
10h 37m
English
O'Reilly Media, Inc.
Content preview from 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:

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

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Getting Started with Microsoft System Center Operations Manager

Getting Started with Microsoft System Center Operations Manager

Kevin Greene
System Center 2012 Operations Manager Unleashed, 2nd Edition

System Center 2012 Operations Manager Unleashed, 2nd Edition

Kerrie Meyler, Cameron Fuller, John Joyner

Publisher Resources

ISBN: 0596009534Catalog PageErrata