Open topic with navigation

The Select Case action enables you to create one or more Case subactions and a single Default action and to specify a variable that the Integration Service evaluates to determine which of those actions to execute. The Case and Default actions themselves are similar to the Group action in that they can contain any number of subactions that are executed when the parent Case or Default action is executed.

You can configure the following properties for the Select Case action:

Action

• Name: A read-only property that specifies the name of the action. The variable that is listed in the name field updates to the variable that you specify in the Cases section of the property page.

• Description: Allows you to save a description for the action.

• Run Action: Allows you to specify how often you want to run the action.

  • Always: Specifies that the Integration Service will run the action each time it runs the integration.

  • Never: Specifies that the Integration Service will not run the action when it runs the integration.

  • Conditionally, based on variable: Specifies that the Integration Service will run the action only when a selected variable meets a specified condition. Use this option in situations where there is only one condition that determines whether or not the action will run. Once you have enabled this option, you can create the conditional statement in the input box provided.

    Input box controls

    • Variable: Enter the variable that you want to use for the conditional statement. Alternatively, expand the dropdown list and select a recently used variable, or select Variables or More Variables to open the Insert Variable dialog.

    • [Relational Operator]: Specifies the relational operator to use for the conditional statement. Click the existing operator to open a list of additional operators, and select the one you want to use. For more information, refer to Relational Operators. The operators available in the list depend on whether you have selected Text or Decimal for the Type option.

    • Value: Specifies the value(s) to use for the conditional statement. Some operators, such as Is null and Is not null, do not require a value to be specified. In these situations, the Value field is not available.

    • Type: Specifies whether the conditional statement is evaluating a text or decimal value.

       

  • Conditionally, based on expression: Specifies the conditions under which the Integration Service will run the action. Use this option for situations that require more than one conditional statement. Once you have enabled this option, you can create the conditional expression in the input box provided by creating the desired conditional statements. You create and edit your conditional expression on the Tree View tab. Click the Text View tab to see a read-only text view of the conditional expression.

    Input box controls (Tree View tab)

    • [Conditional Joiner]: Specifies the conditional joiner for the conditional statements within the group. The default conditional joiner is And.

      Click the existing conditional joiner to access a menu that allows you to configure your conditional expression in one of the following ways:

      • Select a different conditional joiner: The menu options include a list of conditional joiners. Select the conditional joiner you want to use for the conditional statements. For more information about the supported conditional joiners, see Conditional Joiners.

      • Add Condition: Click to add another conditional statement to the current group.

      • Add Group: Click to add a sub-group of conditional statements to the current group.

      • Remove Group: Available in the menu when the menu has been opened from a sub-group. Click to delete the sub-group.

      • Clear All: Available in the menu when the menu has been opened from the top-most group. Click to delete all conditional statements (including sub-groups).

    • : Visible just to the right of each conditional joiner in your expression. Click to add a conditional statement to the group associated with that joiner.

    • :  Visible when you position the cursor over an existing conditional statement. Click to delete the conditional statement.

    • Variable: Enter the variable that you want to use for the conditional statement. Alternatively, expand the dropdown list and select a recently used variable, or select Variables or More Variables to open the Insert Variable dialog.

    • [Relational Operator]: Specifies the relational operator to use for the conditional statement. Click the existing operator to open a list of additional operators, and select the one you want to use. For more information, refer to Relational Operators. The operators available in the list depend on whether you have selected Text or Decimal for the Type option.

    • Value: Specifies the value(s) to use for the conditional statement. Some operators, such as Is null and Is not null do not require a value to be specified. In these situations, the Value field will be hidden.

    • Type: Specifies whether the conditional statement is evaluating a text or decimal value.

Cases

• Select case using variable: Specifies the name of the variable that the Integration Service will evaluate to determine which Case action to execute. Enter a unique variable name that is used only for this action. Alternatively, click to expand the dropdown list and select a recently used variable, or add a variable.

• Add Case: Click to add a new Case subaction to the Cases table. Also adds the Case action to the left Navigation Pane.

• Cases table: Lists each of the Case actions that you created and the condition under which the Integration Service will execute each one.

  You can also specify the condition for a Case action on the property page for the Case action itself. Click the Case action that you want in the left Navigation Plane to open its property page. Changes are updated on both the Case and the Select Case property pages.

 

• Case: The case name reflects the case condition.

• Condition: Click to select the relational operator for the condition, and then enter the values for the condition.

• : Deletes the Case action.

• Specify default case for all other values: When you select this option, a Default subaction is added to the left Navigation Pane. This is a specialized action that does not include an option for specifying a condition. This is the action that the Integration Service will execute when none of the conditions are met for the Case actions that you created.

User Account

• Inherit from parent action: When enabled, the action inherits the user account credentials specified on the Actions property page. Alternatively, if the action is part of a Group action, it will inherit the user account credentials specified on the immediate parent Group action’s property page.

• Specify user credentials: When enabled, the action runs using the credentials specified.

Error Handling and Diagnostics

• Ignore errors and continue running actions: When enabled, specifies that if the action fails, the remaining actions will continue to run.

  When this property is not enabled and the action fails, the resulting behavior depends on the following scenarios:  If you have specified Sequentially for the Execute Actions property of the selected action's hierarchical Actions or Group property page, no further actions within that group are executed. If you have specified In Parallel for the Execute Actions property of the action's hierarchical Actions or Group property page, the actions within that same group are not affected; the errors are ignored and the other actions within the group are executed. If the selected action is within a Group action, no actions outside of that Group action are affected.