Database Administrators Asked on December 3, 2020
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.
Then I Run immediatly
[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.
Warning:
Could not connect source component. Warning 0x80202066: Source - auswahl_hoefken [1]: 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:
Error 0xc02020e8: Source 27 - antrzusatz [157]: 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..
Any ideas?
You might try and check if you can get data out of the Informix database via the linked server. If the direct query fails, you might have some luck with the use of OPENQUERY
SELECT * FROM OPENQUERY ([name of linked server], 'Query text')
If this works, maybe a select into gets the job done.
Answered by Reitse Eskens on December 3, 2020
Get help from others!
Recent Answers
Recent Questions
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP