All SSIS Packages with Oracle as destination are failing With Permission errors

Anonymous
2021-06-27T14:21:47.167+00:00

Hi All,
My SSIS Package loads data from a flat file into Oracle database and has been running for months without any issues, until today all the packages are failing with the below error
[Execute SQL Task] Error: Failed to acquire connection "ORACONNECTION". Connection may not be configured correctly or you may not have the right permissions on this connection.
Nothing has changed permission wise as i was able to connect using TOAD and SQL Plus.

Oracle Version is 12C (12.1.0.2.0) 64 bit.

Visual Studio SSDT Info
Microsoft SQL Server Data Tools for Visual Studio 2017 (SSDT)
Version 15.8.3
VisualStudio.15.Release/15.8.3+28010.2019
Microsoft .NET Framework
Version 4.8.03761

Installed Version: IDE Standard

Microsoft Visual Studio Tools for Applications 2017 00371-40000-00001-AA675
Microsoft Visual Studio Tools for Applications 2017

C# Tools 2.9.0-beta8-63208-01
C# components used in the IDE. Depending on your project type and settings, a different version of the compiler may be used.

Common Azure Tools 1.10
Provides common services for use by Azure Mobile Services and Microsoft Azure Tools.

NuGet Package Manager 4.6.0
NuGet Package Manager in Visual Studio. For more information about NuGet, visit http://docs.nuget.org/.

Project 1.0
Information about my package

ProjectServicesPackage Extension 1.0
ProjectServicesPackage Visual Studio Extension Detailed Info

ResourcePackage Extension 1.0
ResourcePackage Visual Studio Extension Detailed Info

ResourcePackage Extension 1.0
ResourcePackage Visual Studio Extension Detailed Info

SQL Server Analysis Services 14.0.1016.285
Microsoft SQL Server Analysis Services Designer
Version 14.0.1016.285

SQL Server Data Tools 15.1.61808.07020
Microsoft SQL Server Data Tools

SQL Server Integration Services
Microsoft SQL Server Integration Services Designer
Version 14.0.3002.113

SQL Server Reporting Services 14.0.1016.285
Microsoft SQL Server Reporting Services Designers
Version 14.0.1016.285

SsmsVsIntegration 1.0
Information about my package

Visual Basic Tools 2.9.0-beta8-63208-01
Visual Basic components used in the IDE. Depending on your project type and settings, a different version of the compiler may be used.

Visual Studio Code Debug Adapter Host Package 1.0
Interop layer for hosting Visual Studio Code debug adapters in Visual Studio

Please need help.
Thanks

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,468 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 33,626 Reputation points
    2021-06-28T05:42:37.57+00:00

    Hi @Anonymous ,

    Execute SQL Task] Error: Failed to acquire connection "ORACONNECTION". Connection may not be configured correctly or you may not have the right permissions on this connection.

    From the error message, it is like a permissions issue.

    You may refer below methods mentioned in the documentation to see if it could resolve your issue.

    If it doesn't work, we'd suggest that you may use Process Monitor to get more details.

    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

    0 comments No comments