Try starting it from the program files directory instead of program files (x86)
ssis memory errors

^^ :blink: Thanks for mentioning it. The second bummer is SSDT for Visual Studio 2017 (15.8.1) doesn't support designing packages that contain Oracle/Teradata source/destination. Use SSDT for Visual Studio...

Quite dangerous without a test environment.
1. Can I patch from sp1 to sp3 or it has to be in order? -> usually you can patch straight to sp3 as the...

Thats quite a complex nested view to diagnose.
Maybe it is possible to rewrite currentstatus because you have a group by there.for  R_FormNumber, with probably causes the hash match. Good...

A more recent link about tls 12
What version of ssis?

Regarding "I am ignoring all errors during this process"
May an error cropped up and a full batchsize was not imported? (bulk vs individual loads)

Do you have the create table and create index scripts?
Which indexes and in what fieldorder are those on [dbo].[IncidentFormSearchModel] ?
Does your used index  include IncidentStatus?
What version of...

Does is run in a virtualized environment? I had strange cases of VM ballooning denying memory for sql server

Can't find an option. Workaround: setup a job to (re)move old audit files?
C2 to be replaced with Common Criteria Compliance Enabled Server Configuration

see microsoft documentation

Readonly snapshots?
https://docs.microsoft.com/en-us/sql/database-engine/database-mirroring/database-mirroring-and-database-snapshots-sql-server?view=sql-server-2017

Read the link you've included about network io in your post.
Solutions:  revamp the application (select data, improve data handling)
It usually means that sql server is streaming data to...

added * for testing. Len +2 because len trims the rightmost whitespace.

declare @totrim varchar(50)='Reference Number: 878655555 detail, detail, lots of text etc'
declare @toskip varchar(50)='Reference Number:...

Regional settings of the reporting server?
You can alter the default language of a login with ALTER LOGIN

Regarding oracle tuning I refer to orafaq How to tune SQL or Identify Performance Problem and Bottleneck