An administrator can update parameters for the following BAM DTS packages:
The CubeUpdate Data Transformation Services (DTS) package is always located on the same server as the Star Schema database.
The DataMaintenance DTS package is always located on the same server as the Primary Import database.
The DTS packages use the following parameters in the BAMConfiguration.xml file.
Parameter
Description
ConnectionTimeOut
The DTS connection time out value (in seconds) is an integer. If you omit the ConnectionTimeOut parameter, the configuration file uses 60 seconds, the default value.
Encryption
By default, the DTS packages do not encrypt data while they transform the data (Encryption value is 0). Set Encryption to 1 to encrypt the data during transformation.
OwnerPassword
The password for the DTS package owner. DTS package owners can open and modify DTS packages. For information about DTS package owners, see SQL Server Books Online.
UserPassword
The password for the DTS user. DTS package users can run DTS packages. For information about DTS package users, see SQL Server Books Online.
The DTS packages use the following naming conventions in the BAMConfiguration.xml file:
CubeUpdate DTS package
bam_AN_<CubeName >, where CubeName is the name of the cube. The BAM workbook generates the cube name from the view name. If you modify the cube name in the BAM configuration XML document, the new cube name is used in the DTS package name.
DataMaintenance DTS package
bam_DM_<ActivityName >, where ActivityName is the name of the activity.
You run the CubeUpdate DTS package to aggregate the scheduled aggregation. In the next section, you can specify the time window for real-time data aggregation.