Home Forums Data Warehousing Integration Services The data value cannot be converted for reasons other than sign mismatch or data overflow. RE: The data value cannot be converted for reasons other than sign mismatch or data overflow.

  • March 22, 2017 at 7:31 pm

    #1934431

    I faced the same issue and I solved it by : 

    converting the column which has having issue at source side to : DT_WSTR 
    and in the staging the colum data type I kept as nvarchar

    It resolved the issue. 

    Thanks.