cancel
Showing results for 
Search instead for 
Did you mean: 

Custum SSIS control commands

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Guys,

Maybe this will help someone else in the future, it is the syntax list of the SSIS packages. I'm still wondering why this wasn't documented at all...


PROMPT(INFILES, [variable], [label])
PROMPT(OUTFILE, [variable], [label])
PROMPT(SELECT, [variable], [second variable], [label], [dimensions])
PROMPT(SELECTINPUT, [variable], [second variable], [label], [dimensions])
PROMPT(TRANSFORMATION, [variable], [label])
PROMPT(DELIMITER, [variable], [label])
PROMPT(TEXT, [variable], [label], [PWD], [VALIDATE LIST])
PROMPT(COPYMOVE, [variable], [second variable], [label], [dimensions])
PROMPT(COPYMOVEINPUT, [variable], [second variable], [label], [dimensions])
PROMPT(CHECKBOX, [variable], [label], [default value])
PROMPT(CHECKBOXYES, [variable], [label])
PROMPT(CHECKBOXNO, [variable], [label])
PROMPT(COMBOBOX,[variable], [label], [combo box Style], [label List], [default label])
PROMPT(MESSAGE,[label])
PROMPT(RADIOBUTTON,[variable], [label], [default value], [label List], [value List])
PROMPT(CHECKBOXGROUP,[variable], [label], [default value], [label List], [value List])

GETINFO(FACTSELECTION_FROM_FILE,[variable],[FileName],[dimensions])
GETINFO(DELETESTATEMENT_FROM_FILE,[variable],[FileName],[TableName],[Dimensions],[Delimiter],[TimeOrTIMEID])

INFO([variablename], [value])

BEGININFO([variablename])
[value]
ENDINFO

TASK([Task Name], [PropertyName], [PropertyValue])

CONNECTION([ConnectionName], [OleDbPropertyName], [PropertyValue])

Global([variablename], [value])

OLEDBCONN([ConnectionName],[OleDbPropertyName], [PropertyValue])OLEDBCONN([ConnectionName],[OleDbPropertyName], [PropertyValue])

i045436
Advisor
Advisor
0 Kudos

Hi,

From what I know there is no official documentation on this. The information about the OS tasks can be find into the help and the parameters names using the modify package and click on the second button displayed near the package name.

Regards,

Mihaela

Former Member
0 Kudos

Hi,

There has to be some documentation on this somewhere, aren't there any white papers on this subject?

I have managed to get the SSIS packages to do what i need it to do for now, but tomorrow i have a complex package coming up and i think I'm going to struggle

Regards,

Andries