Loading Data Using Integration Services Shell

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

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

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

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

    LOGIN FIG

  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 data load by using the LOADDATA command; for example

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