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