This discussion is archived
3 Replies Latest reply: Jan 23, 2013 2:02 AM by SH RSS

FDM automation from VBScript

986324 Newbie
Currently Being Moderated
Hi

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.

Thanks

Jeremy.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points