Clob datatype from Oracle to SQL

• ishaan99

  SSCertifiable

  Points: 6261

  More actions

  September 14, 2009 at 8:21 am

  #210808

  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