Skip to Content
0
Former Member
Nov 13, 2009 at 03:38 AM

SSIS package

23 Views

Hi gurus,

I need to run some script logic in a DM package and pass to it a Time member (2010.INPUT).

In BPC DM I have -

PROMPT(SELECTINPUT,%TIME%,,"Time",TIME)

INFO(%LOGIC_FILE%,%LOGICPATH%revcalc.lgx)

TASK(Logic_Task,APPSET,%APPSET%)
TASK(Logic_Task,APP,%APP%)
TASK(Logic_Task,USER,%USER%)

TASK(Logic_Task,LOGICFILE,%LOGIC_FILE%)
TASK(Logic_Task,RUNMODE,1)
TASK(Logic_Task,LOGICMODE,1)
TASK(Logic_Task,CHECKLCK,%CHECKLCK%)

I need to get the Time parameter passed to the script logic as

*XDIM_MEMBERSET TIME = %TIME_SET%

What do I need to get %TIME% passed to revcalc.lgx?

I've tried setting TIME and TIME_SET with TASK but in the log TIME is blank.

The package and script do run OK but it isn't restricted to 2010.INPUT.

Cheers,

G.