3 Replies Latest reply on Jan 23, 2013 10:02 AM by SH_INT

    FDM automation from VBScript


      We are currently using FDM to post data to Essbase. The solution I have designed is to use SQL SSIS package to import data from text files into a SQL staging table. I then do some manipulation of the data. I am using SSIS due to the functionality that can be incorporated.

      I then use FDM to import the data from the SQL table using an import script in VB.

      This all works, but what I want to know is if I can call a vbscript from the SSIS package (can be a batch file), to automate the import, validate and export process?

      In essence I need a batch script to run 3 fish process in FDM, so no manual intervention is needed.