The DumpLoad task (OSoftTaskDumpLoad2008.dll) is registered with Microsoft SSIS. See Registering Custom Tasks.
Open a package or create a new package in Microsoft SSIS on the Planning and Consolidation server.
Select the task and add it to the package. See Adding or Modifying Packages.
Open the task and choose
.Fill in the application set, application, and the user ID.
Note
The user ID must have Planning and Consolidation administrator privileges to validate logic files.
Enter the path and name of an import file.
Note
By default, the import process appends the data in the import file to the data already in the database. To change this behavior, select Clear existing data and select the dimensions to clear.
Select the Process Cube option, then select one of the following options:
The Full Process option rebuilds the entire application (cube). Select this option if the application structure is changed.
The FAC2 option processes just short-term data storage (the FAC2 table). The Data Manager imports data to the short-term data storage by default, so there may be no need to process the entire application.
The Refresh Data option clears data from the application and repopulates it with existing data.
Click OK.
Note
You can use TASK commands in the MODIFYSCRIPT Package Variable task to automatically complete the information for you.