teradata lobs are not allowed to be selected in record or indicator modes + SSIS error

Connectivity

teradata lobs are not allowed to be selected in record or indicator modes + SSIS error

I am creating SSIS Package with Teradata OLEDB provider for teradata 14.00.0.1.

my table has column with datatype "Character Large Object". When I try to use this table in my SSIS, it throws following error:

 Exception from HRESULT: 0xC0202009

Error at dft - AREA [ole_src_AREA [22]]: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.

An OLE DB record is available.  Source: "OLE DB Provider for Teradata"  Hresult: 0x80004005  Description: "[Teradata Database] LOBs are not allowed to be selected in Record or Indicator modes. ".

Any solution for this issue?

2 REPLIES
Teradata Employee

Re: teradata lobs are not allowed to be selected in record or indicator modes + SSIS error

Set EnableLobSupport to Yes in the connection string.

Re: teradata lobs are not allowed to be selected in record or indicator modes + SSIS error

Thank you so much NetFx... You are awesome.. It works like charm :)