Post reply

AS400

  • October 12, 2011 at 5:39 am

    #245191

    HI,

    How can we pull the data from AS400 DB through our SSIS...?

    Is that Possible?

    Thanks,
    Charmer

  • October 13, 2011 at 2:33 am

    #1393862

    Yes, it's very possible. A couple of problems i have had in the past revolve around how old the back-end system is and how advanced an ODBC driver you can use.

    but i have done it with 3 systems now.. biggest headache always comes from some ODBC driver issue. (well, version 7 was a breeze.. before version 6 has been a PITA)

  • October 13, 2011 at 3:23 am

    #1393882

    okie then temme the way to extract the data from AS400....Could you?

    Thanks,
    Charmer

  • October 13, 2011 at 3:37 am

    #1393892

    Use the ODBC in a data transform, Source AS400 and destination your SQL server.

    try it first, and then come back with issues.

  • October 14, 2011 at 9:08 am

    #1394696

    You need to install iSeries Access drivers for AS400 in your development machine. Then you will see OLE DB providers for AS400 (iSeries) DB2 database. Make sure you set Force Translate property to 37, then you will see data properly translated to readable format.

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

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