OData Source - SQL Server Integration Services Design Patterns - page 337

URL into a web browser, which can be very useful for debugging purposes. The OData
Source has two modes: when accessing the service using the Collection mode , SSIS
will automatically generate the resource URL for you; when using the Resource Path
mode , you will supply the full URL.

Data Type Mappings

The OData Source will attempt to map the fields of complex types defined within the
service's metadata document to SSIS data flow types. When configuring the OData
Source, the fields in the entity or resource collection or entity set you reference will be
added as external metadata columns for the component. Table 12-2 shows the EDM to
SSIS data type mappings. Given the flexibility of the Entity Data Model, you may find
that certain complex types will not work with the SSIS OData Source.

Table 12-2 . EDM Data Type Mapping to SSIS Types

EDM Type CLR Type SSIS Type

Edm.Binary byte[] DT_BYTES

Edm.Boolean bool DT_BOOL

Edm.DateTime DateTime DT_DBTIMESTAMP

Edm.DateTimeOffset DateTimeOffset DT_DBTIMESTAMPOFFSET

Edm.Decimal decimal DT_NUMERIC

Edm.Double double DT_R8

Edm.Guid Guid DT_GUID

Edm.Int16 Int16 DT_I2

Edm.Int32 Int32 DT_I4

Edm.Int64 Int64 DT_I8

Edm.SByte sbyte DT_I1

Edm.Single float DT_R4

Edm.String string DT_WSTR

Edm.Time TimeSpan DT_DBTIME2

Query Options