OData Source Properties

SQL Server 2012

When you right-click OData Source in the data flow and click Properties, you will see properties for the OData Source component in the Properties window.

Property

Description

CollectionName

Name of the collection you wish to retrieve from the OData service. The CollectionName property is used when UseResourcePath is False.

This property is expression-able, allowing the value to be set at runtime. However, if the metadata of the collection does not match the metadata that was used at design time, a validation error will occur, causing the data flow execution to fail.

DefaultStringLength

This value specifies default length for string columns that have no max length.

Default: 4000

Query

The OData query parameters. This property is expression-able and can be set at runtime.

ResourcePath

Use this property when you need to specify a full resource path, rather than just selecting a collection name. This property is used when UseResourcePath is True.

UseResourcePath

When set to True, the ResourcePath value is appended to the base URL to determine the OData feed location. When set to False, the CollectionName value is used.

Default: False

Community Additions

ADD
Show: