Import of Informix to Sql Server

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!