Clob datatype from Oracle to SQL

  • If I make an OLEDB connection to Oracle(10G) database from SSIS package and select this clob column it doesn’t show any data in preview . If I exclude these 2 cols it shows me all data from that table, so what conversion should I use to get this data out from Oracle inorder to be transferred to Sql Server.I tried a to_char(col) which works in Myeclipse tool but the same fails in SSIS.Any input will be greatly appreciated.

    TIA

Viewing post 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply