Peforming Member Loads Using Integration Services Shell

You can perform a member load by using Integration Services Shell instead of Integration Services Console.

You can manually schedule the batch file by using the AT service in Windows or the cron scheduling daemon on UNIX systems. If you are not sure how to schedule the batch file manually, see the operating system documentation.

  To load members and dimensions with Integration Services Shell, follow the same steps for loading members that you use with Integration Services Console:

  1. Log on to the Integration Server computer by using the LOGIN command; for example

    LOGIN cypress

  2. Connect to the external data source by using the SETSOURCE command; for example

    SETSOURCE DSN=TBC;CODEPAGE=English_UnitedStates.Latin1@Binary;UID=TBC;
PWD=password

  3. Connect to the Essbase Server computer by using the SETTARGET command; for example

    SETTARGET DSN=sequoia;UID=sys;PWD=password

  4. Connect to OLAP Metadata Catalog by using the SETCATALOG command; for example

    SETCATALOG DSN=TBC_MD;CODEPAGE=English_UnitedStates.Latin1@Binary;
UID=TBC;PWD=password

  5. Start the member load by using the LOADMEMBER command; for example

    LOADMEMBER "OTL=TBC Metaoutline;APP=OLAP_TBC;DBN=Basic;FLT_NAME=Filter1"