Sunday, February 26, 2012

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!

SeBaFluDownload 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.|||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.|||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

No comments:

Post a Comment