I have been trying to bring in fields from Lotus Notes db (this is my Data Reader Source). The datatype is ntext. My destination table is SQL server. I am having issues converting ntext to varchar (8000).
I used Data Conversion Transformation to first convert unicode into unicode string(DT_WSTR); then second time to convert DT_WSTR to DT_STR. But it will not let me allow the length to exceed 4000 in SSIS in Data Conversion Transformation. The fields have more than 4000. As a result, I am getting this error:
"Data Conversion failed while converting column "xyz" to column "Copy of xyz". The conversion returned status value 4 and status text "Text was truncated or one or more characters had no match in the target page".
Then, I also tried to: First to change ntext to Unicode text stream [DT_NTEXT]; then second to change DT_NTEXT to text stream DT_TEXT. However, The mapped fields in destination table in SQL serverhave datatype of [varchar] (8000) NULL. When I run the package, I get error code 20276:
Cannot create an OLE DB accessor. Verufy that the column metadata is valid.
I get this error even when I go to the Data Reader Source, Data Conversion Transformation and OLE DB destination and go to properties and set "Validate External Metadata" to False.
Any help is greatly appreciated!!