I have an issue with migration to SQL server 2019.
My Source is Oracle and my Destination is Microsoft SQL Server 2019. My package consists of a simple Data Load task; ODBC Source Connection(oracle)/ and OLE DB Destination connection(2019 SQL server). And data is coming from oracle SQL script.
Issue -> The package is successfully executing but not inserting all rows. If the oracle SQL script is satisfying 100 records the insert is happening for 80 only with no errors or warning.
Have tried :
1) SSDT 2017(15.8,15.9.3,15.9.7)
2) Visual Studio Community 2019 with SQL Server Integration Services Projects (3.10 and 3.12.1)
but facing the same issue.
Note - this issue is resolved when we are changing "TargetServerVersion" from 2019 to 2017 or lower, but when the package is run through the job from SQL server 2019 the count is back to less.
As we need to migrate a lot of packages, we need a solution.
Images of the same package execution below:(correct count from VS 2015 version)
