Post reply

How To Read Data From Mainframe Sequential Files on MVS/0S390 IN SSIS

  • June 16, 2009 at 2:59 pm

    #206559

    Hi,

    I am Newbie in SSIS .Can any tell me is there any we can Read Data From Mainframe Sequential Files on MVS/0S390 IN SSIS to SQL Server.At Present i am Using Informatica and Power Exchange To read Data Through Data MAps.

    Thanks,

    Venkata

  • June 16, 2009 at 3:28 pm

    #1010519

    Can you elaborate on the file type? Is the file fixed length columns, comma delimited, etc?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • June 16, 2009 at 5:40 pm

    #1010558

    HI John-

    It is a Sequential files that is stored on Mainfram GDG.It will be in Ebcidic Format and we need COBOL copy book to read it.Right now i am creating Datamaps using Informatica Power Exchange to read the Data.I would like to know if we can do this in SSIS.

    Hope i expained your Question .

    Thanks,

    Venkata

  • June 16, 2009 at 5:48 pm

    #1010561

    SQL Server since 2000 comes with a few EBCDIC code pages defined, check the thread below for two possible solutions.

    http://www.sqlservercentral.com/Forums/Topic720413-145-1.aspx#bm720674

    Kind regards,
    Gift Peddie

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

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