locked
Problems with SSIS when transfering character data from Mainframe DB2 ebcedic to MSSQL 2012 unicode RRS feed

  • Question

  • Hello

    <u5:p> </u5:p>

    We have problems with SSIS when transfering character data from Mainframe DB2 ebcedic to MSSQL 2012 unicode. The problem is when the date contains control characters such as ebcdic 0x00(the nullcharacter). In some incidents the SSIS will convert the control characters to blank (‘ ‘) and at other times only data up to the control character is transferred and the rest of the data for the specific field in the row is left out .

    We expect SSIS to convert each EBCDIC character to its corresponding unicode character. This is not a problem when creating a C# program which selects data from DB2 and inserts into MSSQL. However, it seems that SSIS has the same issues as C/c++ libraries where the nulll cahracters is used as end-of-stream

    Is there any setting in SSIS so that we transfer ALL control characters to their corresponding unicode character automatically?

    Sincerly

    Hannis Wardum

    Elektron


    Tuesday, March 15, 2016 9:54 AM

Answers

  • Hi Hannis,

    There is no such setting in SSIS.

    But is quite easy to make the load happen by the means of a Transformation Script as described in

    https://www.mssqltips.com/sqlservertip/3438/importing-mainframe-data-with-sql-server-integration-services/


    Arthur

    MyBlog


    Twitter

    • Proposed as answer by Eric__Zhang Wednesday, March 16, 2016 6:12 AM
    • Marked as answer by Eric__Zhang Wednesday, March 30, 2016 12:22 PM
    Tuesday, March 15, 2016 2:16 PM

All replies

  • Hi Hannis,

    There is no such setting in SSIS.

    But is quite easy to make the load happen by the means of a Transformation Script as described in

    https://www.mssqltips.com/sqlservertip/3438/importing-mainframe-data-with-sql-server-integration-services/


    Arthur

    MyBlog


    Twitter

    • Proposed as answer by Eric__Zhang Wednesday, March 16, 2016 6:12 AM
    • Marked as answer by Eric__Zhang Wednesday, March 30, 2016 12:22 PM
    Tuesday, March 15, 2016 2:16 PM
  • Hello Arthur

    Thanks :)

    Tuesday, March 29, 2016 12:04 PM