none
SSIS Debug Host has stopped working

    Question

  • Hi,

    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.

    Tuesday, June 25, 2013 10:35 AM

Answers

  • It must be the overflaw issue, you may want to use the DT_TEXT data type, but I suspect even in this case it is not safe to accept large data from Oracle.

    Arthur My Blog

    Tuesday, June 25, 2013 6:15 PM
    Moderator

All replies

  • It must be the overflaw issue, you may want to use the DT_TEXT data type, but I suspect even in this case it is not safe to accept large data from Oracle.

    Arthur My Blog

    Tuesday, June 25, 2013 6:15 PM
    Moderator
  • But ideally it should be passed to the error output? In this case it debugging crashes?
    Wednesday, June 26, 2013 5:38 AM