Exporting Journal Data 
You can export journal data from Planning and Consolidation using Export Journal.
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 and Modifying Packages.
Open the task and choose .
Enter the application set, application, and the user ID.
Note
The user ID must have Planning and Consolidation administrator privilegesto validate logic files. For more information about validating logic, see Validating Logic.
Enter the path and name of the file to which the journal data is to be exported.
Click OK.
Note
You can use TASK commands in the MODIFYSCRIPT Package Variable task to automatically complete the information for you.