question

Imagine-7947 avatar image
0 Votes"
Imagine-7947 asked OlafHelper-2800 answered

SSIS packages created on VS15 not working on VS2019 Professional edition

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?

sql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered

Hi @Imagine-7947,

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.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

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][1]

[1]: https://www.microsoft.com/en-us/download/details.aspx?id=55179
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.