Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Posts
    3

    Unanswered: Driver to connect to Informix via DTS??

    Hi, folks!

    I want to pump data from Informix to SQL Server using DTS to fill / fresh up my SQL-Server data warehouse every day.

    In the SQL documentation I found "Don't use the ODBC driver from Informix"

    Which is a good choice of ODBC/OLE-DB drivers to deal with Informix via SQL servers DTS?


    Regards from Berlin!

    SeBaFlu

  2. #2
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311

    Re: Driver to connect to Informix via DTS??

    Download Informix driver from IBM website and set it up on your machine to create a DTS package. I have used it to create a DTS package and run it for over a year now.

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    What was the error with current driver?
    That was a general recommendation, but to followup the data import/export as referred comaptible driver must be used.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  4. #4
    Join Date
    Mar 2004
    Posts
    3

    Re: Driver to connect to Informix via DTS??

    Hi, Joe!

    Originally posted by joejcheng
    Download Informix driver from IBM website and set it up on your machine to create a DTS package. I have used it to create a DTS package and run it for over a year now.
    OK, let's try it <s>...

    ... but may be I'm stupid - but I can't find any ODBC driver at the IBM site - can You advice me to the related URL?


    Many thanx from Berlin!

    SeBaFlu

Posting Permissions

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