SSIS Components for Microsoft Dynamics 365

Build 24.0.9175

MultiSelectPickListOptions

Contains the values (options) for MultiSelect Picklist metadata attributes. Only available when Edition is set to CustomerService, FieldService, Marketing, ProjectOperations, or Sales.

Select

The component will use the Microsoft Dynamics 365 API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the component.

  • TableName supports '=','IN' operators.

For example, the following queries are processed server side:

SELECT * FROM MultiSelectPickListOptions WHERE TableName = 'teams'

SELECT * FROM MultiSelectPickListOptions WHERE TableName IN ('accounts', 'teams')

Columns

Name Type Description
ColumnName String The name of the column representing the multi-select picklist attribute.
Color String The color associated with the picklist option, typically used for UI representation.
ExternalValue String The external value associated with the picklist option, used for integration or mapping purposes.
HasChanged String Indicates whether the picklist option has been modified since its creation.
IsManaged Boolean Specifies whether the picklist option is part of a managed solution.
Label_LocalizedLabels String Localized labels providing display names for the picklist option in various languages.
Label_UserLocalizedLabel_HasChanged String Indicates if the user-defined localized label for the picklist option's label has been modified.
Label_UserLocalizedLabel_IsManaged Boolean Specifies whether the user-defined localized label for the picklist option's label is managed.
Label_UserLocalizedLabel_Label String The actual text of the user-defined localized label for the picklist option's label.
Label_UserLocalizedLabel_LanguageCode Integer The language code associated with the user-defined localized label for the picklist option's label.
Label_UserLocalizedLabel_MetadataId String The unique identifier for the metadata of the user-defined localized label for the picklist option's label.
Description_LocalizedLabels String Localized labels providing descriptions for the picklist option in various languages.
Description_UserLocalizedLabel_HasChanged String Indicates if the user-defined localized label for the picklist option's description has been modified.
Description_UserLocalizedLabel_IsManaged Boolean Specifies whether the user-defined localized label for the picklist option's description is managed.
Description_UserLocalizedLabel_Label String The actual text of the user-defined localized label for the picklist option's description.
Description_UserLocalizedLabel_LanguageCode Integer The language code associated with the user-defined localized label for the picklist option's description.
Description_UserLocalizedLabel_MetadataId String The unique identifier for the metadata of the user-defined localized label for the picklist option's description.
MetadataId String The unique identifier for the metadata of the picklist option.
ParentValues String The parent values associated with the picklist option, used when the option is part of a hierarchical structure.
Value Integer The numeric value assigned to the picklist option.
TableName String The name of the table containing the multi-select picklist attribute.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175