Post reply

Importing data from AS400 into SQL 2005

  • May 4, 2009 at 1:45 am

    #131065

    Hi All

    Is there anywhere where I can find some info on how to go about importing data from AS400 into SQL 2005 server? Can I use DTS, or SISS for this operation?

    I need to find out how to do it from scratch.

    Thanks for any help.

  • May 4, 2009 at 1:55 am

    #987963

    Hello,

    Do you need the data in SQL 2005 to be current, or are you thinking about a batch process e.g. one data load per day?

    I know IBM have a product that replicates data to SQL Server on-line (I can’t remember the product’s name just at the moment).

    For a batch process then SSIS would probably be the way ahead. In which case, may be take a look at the Integration Services Tutorial section in SQL Server Books Online, or the following MS Article:-

    http://technet.microsoft.com/en-gb/library/cc917721.aspx

    BTW –-SSIS replaces DTS i.e. you wouldn’t want to use DTS for a new development.

    Regards,

    John Marsh

    www.sql.lu
    SQL Server Luxembourg User Group

  • May 4, 2009 at 2:36 am

    #987972

    Hello again,

    I’ve just remembered … IBM’s product is called DataMirror, and here is a relevant link:-

    http://www-01.ibm.com/software/data/integration/dm/

    Regards,

    John Marsh

    www.sql.lu
    SQL Server Luxembourg User Group

  • May 4, 2009 at 3:47 am

    #987997

    Hi John

    Thanks very much for the help. I'll both suggestions a try.

    Thanks again

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

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