Show TOC

Procedure documentationRestoring Journal Data Locate this document in the navigation structure

 

To restore journal entry data from a text file, choose Restore Journal Data.

Prerequisites

The DumpLoad task (OSoftTaskDumpLoad2008.dll) is registered with Microsoft SSIS. See Registering Custom Tasks.

Procedure

  1. Open a package or create a new package in Microsoft SSIS on the Planning and Consolidation server. See Adding and Modifying Packages.

  2. Select the task and add it to the package.

  3. Open the task and choose   Data Management   Import into SQL  .

  4. Fill in the application set, application, and the user ID.

    Note Note

    The user ID must have Planning and Consolidation administrator privileges to validate logic files.

    End of the note.

  5. Enter the path and name of the file that contains the target journal data.

  6. Click OK.

Note Note

You can use TASK commands in the MODIFYSCRIPT Package Variable task to automatically complete the information for you.

End of the note.