Show TOC

Procedure documentationExporting from Microsoft SQL Server Locate this document in the navigation structure

 

You can export an ASCII text file that contains data from your Planning and Consolidation database.

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 or Modifying Packages.

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

  3. Open the task and choose   Data Management   Export from 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 an export file.

  6. Select Export time in timeID if you want the time members to use the TIMEID rather than time member names.

  7. Select a time measure from the Measure list.

  8. You can enter a selection file that contains either of the following methods for specifying members:

    • A list of dimensions and members to export

    • An SQL statement that returns the member list needed for export

  9. 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.