Package Parameters are a way to execute packages with different arguments depending on external factors.

For example you could create a package that takes as an argument a product id and then create a SSIS process to execute the package for each product.

Designing Packages With Parameters

Package parameters are added to packages on the format:

{@parametername[default:value][datatype:value]}

You can use each parameter multiple times, but you can only define it once.

Default value is always used when user executes package without specifying the parameter value.
exMon Portal uses the datatype value to give user proper input control, for example a date and time picker.

You only have to define a parameter once, in Working Directory or Command and you will have access to the parameter in both of the same UAT.

Parameter datatypes

Datatypes affect only the input control for Portal. They affect text alignment as well as which control is used. Note that datatypes are not case sensitive.
Available datatypes are:

Left alignment

  • String
  • Varchar
  • Char
  • No datatype definition

Right alignment:

  • Int
  • Int32
  • Long
  • Int64
  • Short
  • Int16
  • Decimal
  • Double

Datepicker

  • Date
  • Datetime

Executing with package parameters

When user executes a package that has defined a parameter with default value, the package will use that default value in all executions where user does not explicitly define a value for said parameter.

You can for example execute the package above in two ways:

epcmd --startpkg 1 --uat DEV --@countandsize 32 --@path c:\
epcmd --startpkg 1 --uat DEV

When executing package that defines parameters from exMon Portal you are prompted to fill in the required parameters. If a parameter has default value defined, that parameter’s input box will be filled with it by default.