Recording Member and Data Load Scripts

If you are creating scripts to perform loads or other tasks, you may want a script generated by Integration Services to use as a model or you may want to check your script syntax for Open Database Connectivity (ODBC) data source connection details. Record a load script with Integration Services by performing a load and recording the load script to a script file.

  To record a load script:

  1. Start Integration Services Console and open a metaoutline.

  2. Select Outline > and one of the following menu items:

    • Member Load

    • Data Load

    • Member and Data Load

  3. In the Essbase Application and Database dialog box, type or select the appropriate application and database names.

  4. Click Next to display the Schedule Essbase Load dialog box.

  5. Save the load to a script file by clicking Only Save Load Script and then click Save Scripts.

  6. In the Save Script As dialog box, type a name for the script that you want to save, and then click OK.

  7. Click Finish to start the load or to complete scheduling of the load.