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