How to map (oracle) CLOB as a source?
I am trying to load data from Oracle and one of the source tables has a column of CLOB data type.
There is obviously a problem with BIML because it should be mapped as AnsiString with length=-1. The packages is created succesfully but after running it fails because of "needs new metadata".
Then I opened source code of the package and I found out that the CLOB column is mapped as STR and not TEXT :-(