Skip to Content
0
Former Member
Apr 29, 2009 at 08:52 AM

Custum SSIS control commands

18 Views

Hi Guys,

I have to do a few custom data and dimension synchronization packages and i would like to know if someone knows where i could get a list of commands or guide on how to go about the advanced settings of the data packages.

An example would be:

'DEBUG(ON)
'PROMPT(SELECTINPUT,,,"Please select current Budget yeat",%TIME_DIM%)
PROMPT(SELECTINPUT,,,"Please select intersection that is needed",%ENTITY_DIM%)
TASK(Execute formulas,USER,%USER%)
TASK(Execute formulas,APPSET,%APPSET%)
TASK(Execute formulas,APP,%APP%)
TASK(Execute formulas,LOGICFILE,%APPPATH%\..\AdminApp\%APP%\InventoryStep1.lgf)
TASK(Execute formulas,SELECTION,%SELECTIONFILE%)
TASK(Execute formulas,LOGICMODE,1)
TASK(Execute formulas1,USER,%USER%)
TASK(Execute formulas1,APPSET,%APPSET%)
TASK(Execute formulas1,APP,%APP%)
TASK(Execute formulas1,LOGICFILE,%APPPATH%\..\AdminApp\%APP%\InventoryStep2.lgf)
TASK(Execute formulas1,SELECTION,%SELECTIONFILE%)
TASK(Execute formulas1,LOGICMODE,1)
TASK(Admin Task,DESCRIPTION,Admin_Process)
TASK(Admin Task,APPSET,%APPSET%)
TASK(Admin Task,APP,%APP%)
TASK(Admin Task,USERID,%USER%)
TASK(Admin Task,PROCESSMODE,3)
TASK(Admin Task,PROCESSOPTION,2)
TASK(Admin Task,APPLICATIONLIST,FINANCE)

Does anyone have a document on the different options available to us when using the all the commands? Or even just what each one of them does/syntax?

Regards,

AvdB