question

AvireniUpendar-3214 avatar image
0 Votes"
AvireniUpendar-3214 asked AvireniUpendar-3214 commented

Oracle Attunity issues in VS2017 & SSDT2017

Hi Team,

We're good with SSIS packages(which don't have Oracle attinuity connection) build/deployment either manual/AzureDevops pipeline in VS2107/SSDT2017.
While we're unabale to open SSIS packages(which have Oracle attinuity connection) with the attached screenshot error in VS2107/SSDT2017. And getting the below
error while trying to do manual deployment.

'Failed for ProcessID : 1463 with error : The component is missing, not registered, not upgradeable, or missing required interfaces.
The contact information for this component is "Oracle Source; Microsoft Connector for Oracle by Attunity; Attunity Ltd.; All Rights Reserved;'

And we have the below software in our machine currently.

Microsoft Visual Studio 2017 Professional 15.9.7
Microsoft SQL Server Data Tools - Visual Studio 2017 14.0.16186
Microsoft Connector for Oracle by Attunity 3.0
Microsoft Connector for Oracle by Attunity 4.0
Microsoft Connector for Oracle by Attunity 5.0

Please let me know if you need more details.
Could you please check and advise us how to resolve this issue.101327-microsoftteams-image.png



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.

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered AvireniUpendar-3214 commented

Hi @AvireniUpendar-3214

Which Edition of SQL Server/SSIS are you using?

Attunity data Provider is only supported by Enterprise Edition as said here.

If you are using Enterprise Edition and the issue still occurs.

Please refer this and here is a fix for the issue.

A fix for this issue has been released! Install the most recent release from https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-2017 .

Regards,

Zoe


If the answer is helpful, please click "Accept Answer" and upvote it.

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.
Hot issues October


· 2
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.

If you have any updates, don't forget to tell us.

0 Votes 0 ·

Hi Zoehui,

Thanks for the response.

Please find we're unable to open SSIS packages using the below VS2107 Enterprise also.

Microsoft Visual Studio 2017 Enterprise 15.9.8 (15.9.28307.481)
Microsoft SQL Server Data Tools - Visual Studio 2017 14.0.16182.0
Microsoft SQL Server 2016
Microsoft SQL Server Integration Services Projects 15.0.2000.68 (Version 2.1 in VS2017 extensions)

Even we already installed SSDT using VS installer only as per https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-2017.

Kindly advise on this.

0 Votes 0 ·