January 6, 2015 at 4:45 am
I am belatedly transferring my SSIS Development Environment from Windows XP to another machine, which runs Windows 7. I have transferred everything across, but when I open a package in the new environment, I get the following message:
Error loading <PackageName>.dtsx: The connection type "MSORA" specified for connection manager "OracleConnector" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.
There is obviously something missing on my new machine. Please can some kind person suggest a few things for me to check?
Thanks in advance to all who try to help.
Mark Thornton
January 6, 2015 at 1:29 pm
You most likely need the Oracle client. For SSIS, you will want to instal the 64 bit and 32 bit clients, since the Data Tools are a 32 bit application. Google for Instant Client, and you should be able to download it freely.
January 6, 2015 at 2:36 pm
After installing the client, also make sure you have installed the Microsoft OLE DB provider for Oracle (which is MSORA if I'm not mistaken).
I think it is only available for 32-bit and is deprecated as well.
Personally I go with the Oracle OLE DB provider which is also available in 64-bit. If it is not installed alongside the client, try installing the ODAC tools.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply