Scenario: Your nightly MOM DTS job has failed a few times, and now MOM is trying to send large amounts of data which may be causing issues. So you need to run the DTS job manually instead to control the number of days being moved. Here’s how

MOM.Datawarehousing.DTSPackageGenerator.exe /latency:30 /srcserver:OnePointDBServer /srcdb:OnePoint /dwserver:WarehouseServer /dwdb:SystemCenterReporting /product:"Microsoft Operations Manager”

The /latency switch tells that all data older than 30 days will be moved. I suggest you start with a big number and work your way down to 4 days, which is the default grooming threshold on the Onepoint side (Glboal Settings, Database Grooming tab).

WARNING: If your nightly DTS job has been failing for an extended period, be sure to move data in small chunks, as it is a logged operation and will fill your transaction log and fail if you attempt to recover in one step.

DTSPackageGenerator switches for manual operation are listed below

Usage:

MOM.Datawarehousing.DTSPackageGenerator

/product: Product name.

(Default=Microsoft Operations Manager)

/srcserver: Source server name.

(Default=.)

/srcdb: Source database name.

(Default=OnePoint)

/dwserver: Datawarehouse server name.

(Default=.)

/dwdb: Datawarehouse database name.

(Default=SystemCenterReporting)

/savetodisk Indicates package save.

(Default is do not save)

/savepath: Path to save.

(Default=)

/donotrun Indicates do not run.

(Default is to run)

/silent Indicates to hide the console window.

(Default is to show)

/maxconn: Max connections. Controls how many steps can run in parallel.

(Default=8, MinimumRequired=5)

/latency: Latency in days. Indicates how much latency (in days) to subtract

from the current UTC date while computing t

he high watermark. All rows that satisfy (Current UTC date - latency) will

be transferred.

(Default=0.0034722222222222222222222222 (5 minutes))

/chunksize: Chunk size in days. High volume data will be transferred in

increments of the chunk size, thereby enabling

transfer of high volume data with limited log space. Specifying 0 will not

chunk the data.

(Default=1 day)

/maxchunks: Maximum number of chunks to create when chunking is enabled.

(Default=10 chunks)

/usesqlauth Indicates use SQL Authentication.

SQL Authentication should not be used and was added only to

support the MSN scenario.

(Default is to use Windows Authentication.)

/srcsqllogin: Source SQL Login. Used to connect to the source database.

Used only for SQL Authentication.

SQL Authentication should not be used and was added only to

support the MSN scenario.

(Default=)

/srcsqlpwd: Source SQL Password. Used to connect to the source database.

Used only for SQL Authentication.

SQL Authentication should not be used and was added only to

support the MSN scenario.

(Default=)

/dwsqllogin: Warehouse SQL Login. Used to connect to the warehouse database.

Used only for SQL Authentication.

(Default=)

/dwsqlpwd: Warehouse SQL Password. Used to connect to the warehouse

database. Used only for SQL Authentication.