I'm trying to update columns in my SQL Server Compact Edition 3.5 DB through OLE DB COMMAND in SSIS 2012.
When I update a column with NTEXT datatype my SSIS Debug Host stops working.
Otherwise I could update all the other columns with datatypes like nvarchar,int,numeric,datetime.
I'm trying to update with value from ORACLE 11g DB Column of the datatype VARCHAR by using the data conversion Unicode text stream.
Kindly suggest a solution.