All Forums Connectivity
pratikmehta9 2 posts Joined 05/14
02 Jul 2014
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?

 

 

 

NetFx 346 posts Joined 09/06
02 Jul 2014

Set EnableLobSupport to Yes in the connection string.

pratikmehta9 2 posts Joined 05/14
02 Jul 2014

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

You must sign in to leave a comment.