I have an Informix Database and a Microsoft SQL Server 2016. My task is to dump the whole Informix Database and export it to the Microsoft SQL Server Database. I installed the Informix SDK 4.5. I also have installed the ODBC drivers 32bit/64bit. The connection is working fine.
I linked the Informix Server within the
Microsoft SQL Server Management Studio, but i was not able to get table information, so i found a workaround in IBMs Documentation.
Now I wantet to try an export with
Import and Export Data (64-bit). I chose the data source as
IBM Informix OLE DB Provider
Data Destination is
SQL Server Native Client 11.0
As a test export i choose some tables. The table Mapping looks fine for me
The next step shows the Type Conversion with an error, but i dont know why.
[Source Information] Source Location : sospos@sosposdbtest Source Provider : Ifxoledbc.4 Cannot locate the mapping file to map the provider types to SSIS types
After that I get errors and warnings.
Could not connect source component. Warning 0x80202066: Source - auswahl_hoefken : Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used.
Error 0xc02020e8: Source 27 - antrzusatz : Opening a rowset fo ""sospos":"sosgx"."antrzusatz"" failed. Check that the object exists in the database.
I get this Warnings for several tables..
I think there is a problem with the table mapping or something like that, but I'm not sure..