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 able to...

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...