Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    176

    Unanswered: DTS from AS 400 to Sql server

    Hi DBA's:

    I need to transfer data from my source database which is Client Access iSeries AS 400
    running DB 400 to my database in SQL Server 2000. Here is what I need to do -

    There are files in the Production Enviornment on the DB 400. I need to connect to these files from my SQL Server 2000 database using DTS Wizard and tranfer these files into the tables of my SQL Server 2000 database. Can someone walk me through with the options on the source side of the DTS that I need to choose in order to connect to my AS 400 and get the data.

    Thanks in anticipation.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    I'm assuming you mean DB2, not DB 400...

    Look up sp_addlinkedserver in BOL
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •