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

3. Right-click on the OData Source component on the data flow's design
surface and select Show Advanced Editor.
4. Select the Input and Output Properties tab.

5. Expand the Output folder.
6. Expand the Output Columns folder.
7. Select the column you want to modify.

8. Select the DataType property.
9. Change the value to the new SSIS data type and the Length value, if
appropriate, for the type.

You will only be able to change the DataType property for certain types. Table
12-5 contains a list of data types that are interchangeable. Changing the value for an
unsupported data type will result in an error message ( COMException
0xC020837D ).

Table 12-5 . Data Types That Can Be Changed

Data Type Compatible Type

DT_NTEXT DT_WSTR

DT_IMAGE DT_BYTES

DT_DBTIMESTAMP2 DT_DBTIMESTAMP

Conclusion

This chapter described the new OData Source component in SSIS. OData has seen a
steady increase in adoption over the past few years, and the OData Source provides an
out-of-the-box solution for reading data from a variety of sources, such as SharePoint,
and the Windows Azure Storage APIs.