Also here: http://www.c-sharpcorner.com/forums/msg-537-level-16-state-3-procedure-recovertruncateddataproc-lin. Looking at your posting history, you have 106 posts over nine years. Normally I'd expect someone working on SQL Server over that time to be...

You could try converting to a datetime2 data type - on my machine that produces the leading zero:

declare     @dt varchar(30) = '2012-06-03 04:11:49:16'

select...

The problem is that you haven't given your first table an alias:

IF OBJECT_ID('IsFirstRemit_D') IS NOT NULL

TRUNCATE TABLE IsFirstRemit_D;

SELECT MIN(a.ClaimDetailID) as ClaimDetailID

,a.FacilityPrefix

,a.AccountNumber

,a.RemitDate

--INTO IsFirstRemit

FROM Adena_EDI_16.dbo.Remit835_ClaimDetail_D a

JOIN (SELECT FacilityPrefix, AccountNumber, MIN(RemitDate) as MinRemitDate...

Try the Attunity drivers: https://docs.microsoft.com/en-us/sql/integration-services/data-flow/oracle-connector?view=sql-server-2017

Since installing and using these the performance of our SSIS job has improved dramatically

I'd suggest you ask the DBA to set up a new database on the server (granting db_owner permissions to the Active Directory group you are using to log on), plus...

Just a thought - if the data you are receiving has a SAON in it the data is being sourced from either a local government property gazetteer or the national...

I remember seeing the comment "What has she done now?". Unfortunately, apart from the discourtesy, the author had not checked how his code rendered - it appeared in an email...