SQL Server at some point (2012? 2014?) added the datetime2 to be more compatible with Oracle and DB2's date/time data types that can have more scale in the sub-second part of time values.
in SSIS, I think you'd first target casting the source value to DT_DBTIMESTAMP2 , and then convert it to DT_DBTIMESTAMP, to target a datetime field in SQL Server.
Or, cast it from within the Oracle query to a string pattern SQL Server can implicitly convert.
Or, other options, too, such as string manipulations.