SSIS Components for Salesforce

Build 26.0.9770

DataType

Defines a data type that can be used for fields or values within the org.

Columns

Name Type References Description
Id String Unique identifier for the record.
DurableId String ID of the Durable associated with this record.
DeveloperName String The unique name used by the API and managed packages.
IsComplex Bool Indicates whether the record has the Complex characteristic.
ContextServiceDataTypeId String ID of the ContextServiceDataType associated with this record.
ContextWsdlDataTypeId String ID of the ContextWsdlDataType associated with this record.

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.

Name Type Description
SOQL String Specifies the SOQL query to execute against the Salesforce servers. If this pseudo column is set from the WHERE clause it will take precedence over the original query.
ExternalIdColumn String Specifies the external Id column to use if performing an insert. If this value is specified, upsert will be used when the INSERT command is called.
FilterScope String Optional scope to limit the records returned from queries. This property can take one of these values: Delegated, Everything, Mine, MineAndMyGroups, My_Territory, My_Team_Territory, or Team.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770