Networks

Question

Locked

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 -

Resolved???

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

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

Collapse -

Resolution...

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