I need to import v7r3 ibm i (as400) info to a sql 2019 database

• Rollie D Moe

  Old Hand

  Points: 311

  More actions

  April 3, 2023 at 7:21 pm

  #4168644

  I need to import as400 data into sql 2019 database.  In Sql i can run a linked server to access the as400 data fine.  When i look for the same data source to copy all the data to a database, i don't see the one i need, any help would be fantastic.

• frederico_fonseca

  SSCoach

  Points: 16251

  More actions

  April 3, 2023 at 7:56 pm

  #4168647

  you need to install IBM's odbc driver for I series - see https://www.ibm.com/docs/en/i/7.2?topic=oa-set-up-your-system-i-access-odbc-driver

  with it you can use SSIS or C#/Powershell to connect to your as400 and then load data onto your sql server.