Our forums are currently in maintenance mode and the ability to post is disabled. We will be back up and running as soon as possible. Thanks for your patience!



Import of Informix to Sql Server

By Sandra.DeMuth ·
Hello -

I need to schedule the import of four tables daily from an Informix database to Sql Server. I am running Sql Server 2005 on Windows Server 2003. The Informix database is Informix 2000.

I tried to schedule an SSIS package to run and am having connection problems. Avaya is the vendor selling a database called CMS. They provided me only with OpenLink ODBC 5.2 for a driver. All this seems to be able to do is import into MS Access. This does not work with oledb.

Does anyone know of any way I can get around this problem? ANY suggestions at all will be appreciated!

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -


by ramjef97 In reply to Import of Informix to Sql ...

Have your figured this out? If so, can you post your findings?

Collapse -


by mohsin4u In reply to Resolved???

I have done this job by fetching the data from Script task and then to XML file.
Now from the XML file i bulk load the data into SQL Server 2005 table. Its working fine for me.
But im looking for some efficient way out. For now i dont have the identity columns from that i can figure out the changes in the informix tables; thats why i have to do DELETE and INSERT technique
I'm looking for some more smart way; just to capture the changes and to put them in my system.
Can anyone else has some better solution?

Collapse -

code for VB script

by jbflowers In reply to Resolution...

Hi - can you post the code from your script task that you use to import the data? I am struggling with this in SSIS as well - thanks!

Related Discussions

Related Forums