SSIS packages created on VS15 not working on VS2019 Professional edition

Question

I have created multiple packages using Visual Studio 2015 shell integrated and Microsoft Attunity connector 5.0
We recently moved to Visual Studio 2019 Professional and all the packages have stopped working.

I am getting multiple errors while loading the old packages:

• The component metadata for "Oracle Source" could not be upgraded to the newer version of the component. The perform upgrade method failed.
• The connection type "Oracle" specified for connection manager "oracle_v" is not recognized as a valid connection manager type.

Is this because of the Attunity connector? Does this require me to change each and every package I ever created ??
Is there an automatic way to do this?

Answer 1

Hi @Imagine ,

Here is a same issue that the connection to Oracle could not be upgraded to the newer version of the component.

attempting-to-use-2019-for-2014-ssis-package-and-m.html

He finally got VS 2017 to work and open Oracle Packages.

Please have a double check.

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Microsoft Attunity connector 5.0

That connector is part of Enterprise Edition, not included in default installation of Visual Studio & SSDT:

Microsoft Connectors v5.0 for Oracle and Teradata