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

    Unanswered: DTS from Informix database

    Hi,

    I want to transfer data from an Informix database using DTS. What driver do I need to use for that? What are the settings for the Data Source Name? Has anyone of you accomplished DTS from Informix to SQL Server?

    Let me know if you have any ideas that you can share.

    Thank you.

    Vivek

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    You can get the informix oledb provider from the informix client sdk cd - then use that provider in your dts package.

  3. #3
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311
    There is a known bug in that package. Check out IBM website for more information on that. It will save you a lot headaches.

  4. #4
    Join Date
    Feb 2002
    Posts
    2,232
    Which version and bugs ...

  5. #5
    Join Date
    Feb 2002
    Posts
    2,232
    Also, as with any informix product - make sure you read the release notes.

  6. #6
    Join Date
    Sep 2003
    Posts
    176
    How much will I have to pay for this driver that you are talking about?

  7. #7
    Join Date
    Sep 2003
    Posts
    176
    Also what version of the Informix Client SDK should I get hold of? I have no experience in Informix.

  8. #8
    Join Date
    Feb 2002
    Posts
    2,232
    Here is the link to ibm/informix client sdk (includes release notes):

    link

Posting Permissions

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