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!
