Windows 10: Unable to call Oracle SOAP service using SSIS MS visual studio

Unable to call Oracle SOAP service using SSIS MS visual studio

:)

 

SSIS with Oracle connection doen't work in SQL job agent

I use Oracle connection in SSIS. There are two ways to access Oracle data in SSIS package, one is MSORA Connector (Microsoft Connector for Oracle by Attunity), another is ODBC connection.

I can use both ways when execute in visual studio. But it can’t be done in SQL server as step
in job agent.

Do you know what's the matter cause this issue? Thanks!

 

ODBC connection to oracle database in SSIS

Following error occurs while creating ODBC connection to Oracle database 12c in SSIS





i have created ODBC DSN which itself is connecting to database. When using the same DSN in visual studio 2012 for ODBC connection to Oracle Database 12c. The error occurs.

Following are the resources used:

1.ssdt - VisualStudio(2012 shell integrated) x86

2. Oracle database 12c

3. ORACLE DRIVER (SQORA32.dll)

4. WINDOWS 7 (64bit)

 

Visual Studio keeps crashing when I try to open an SSIS project (new or old)

Hi,

I had been using Visual Studio Professional 2019 for a a few years now to create/modify SSIS packages with no issue...but in the past few months my Visual Studio has started crashing any time I try to create (or open an existing) SSIS project.

I've been looking at the Event Viewer and these are 2 errors I get when Visual Studio crashes:

First: Application: devenv.exe

Framework Version: v4.0.30319

Description: The process was terminated due to an internal error in the .NET Runtime at IP 72311A33 (722F0000) with exit code 80131506.

Second: Faulting application name: devenv.exe, version: 16.11.32510.428, time stamp: 0x627b1042

Faulting module name: clr.dll, version: 4.8.4341.0, time stamp: 0x6023024f

Exception code: 0xc0000005

Fault offset: 0x00021a33

Faulting process id: 0x4a4c

Faulting application start time: 0x01d87044f9bb1b44

Faulting application path: C:\Program Files (x86)\Microsoft Visual Studio\2019\Professional\Common7\IDE\devenv.exe

Faulting module path: C:\Windows\Microsoft.NET\Framework\v4.0.30319\clr.dll

Things I've tried:

• I've checked memory - and no issues with that.
  
• Uninstalling and reinstalling Visual Studio 2019
  
• Uninstalling and reinstalling SSMS (worth a shot right?)
  
• Tried to use Visual Studio 2017 - but same issue
  

Any suggestions to fix this issue is appreciated!

Thank you