Post reply

EBCDIC To ASCII

  • January 17, 2011 at 12:02 am

    #230260

    Hi,

    I need to import data from IBM mainframe to SQl server 2008.

    In mainframe data is stored in EBCDIC format. Is there any way in SQl server server to convert EBCDIC into ASCII or I have to create a lookup table and have to write some function to convert EBCDIC into ASCII. If any one had done same excersice before please let me know the approach.

    Or

    Anyone had any other idea to deal with this.

    Thanks in advace

    Kuldeep panwar

  • January 17, 2011 at 3:01 am

    #1274152

    Hi,

    Have a look at

    http://support.microsoft.com/kb/216399

    I've used Java awell in the past to convert from EBCDIC to ASCII. You can also get JDBC drivers for the AS400 and push to SQL directly.

    Cheers

  • January 17, 2011 at 3:25 am

    #1274170

    Thanks.

    Can we do same in Sql Server or in SSIS directly.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply