Post reply

AS 400 to SQL server using DTS

  • October 3, 2007 at 2:55 am

    #182131

    Hi,

    I have to import the data from AS/400 to SQL server 2000 through DTS.

    Can anyone suggest the steps i have to go through...

    Thanks in advance,

    Raj

  • October 4, 2007 at 3:32 am

    #738977

    did not set this up myself so do not have details but...

    AS400 so presume the database is DB2? You will need to install the DB2 client software on your SQL server to get the drivers you need. As part of this you will specify connection string to the AS400.

    Set up a userid on the DB2 database with the permissoin required and use this id to connect to DB2 from the DTS package.

    Use the 'other connection' icon in DTS when specifying details for the connection to the DB2 database.

    As I said not detailed but a starter for 10.

    george

    ---------------------------------------------------------------------

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

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