Trying to import from Informix to MSSQL 2008 64bit. I have gotten to were I can choose which tables to import, but when clicking next it fails with the error below. Any ideas or suggestions on how to get around this? Source odbc driver: IBM Informix OLE DB Provider Target odbc driver: SQL Server Native Client 10.0 Error message: TITLE: SQL Server Import and Export Wizard Column information for the source and the destination data could not be retrieved, or the data types of source columns were not mapped correctly to those available on the destination provider. "ifas":"bsi"."im_page" -> [bsi].[im_page]: - EIX000: (-674) Routine (oledbtype1) can not be resolved.

there is also ADO.NET data provider for Informix here: http://uda.openlinksw.com/dotnet-informix-mt/ did you tried it?http://www.rad.pasfu.com My Submitted sessions at sqlbits.com

Have not tried it yet. Never even heard of it, I will check it out thanks! Migrating Informix and Oracle to mssql since 2007.

Anyone else have any ideas on how I can get this to work with SSIS?Migrating Informix and Oracle to mssql since 2007.

Hi migrater, Please refer to the following link and see if it works for you, SQL Server Import Export Wizard fails while trying to retrieve the data from Pervasive Database: http://blogs.msdn.com/b/dataaccesstechnologies/archive/2010/09/09/sql-server-import-export-wizard-fails-while-trying-to-retrieve-the-data-from-pervasive-database.aspx Hope it could help you. Thanks, Eileen