title: SSIS - Loading Japanese Double byte data from DB2 to SQL Server 2017 is giving conversion error
body: <p>I am trying import data from DB2 which has double byte Japanese(1027) data into SQL Server 2017 using SSIS</p>
  
  <p>Tried using data conversion before inserting data "<code>932 (ANSI/OEM - Japanese Shift- JIS)</code>". Tried using Unicode <code>string[DT_WSTR]</code> still the same issue</p>
  
  <blockquote>
    <p>[Data Conversion [2]] Error: Data conversion failed while converting column "ABC" (286) to column "A\cABC"(38).  The conversion returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".</p>
  </blockquote>