I am extracting from SAP ERP into SQL Server using a commercial SSIS connector which has been working fine.
But when I extract a certain table some data disappears. For example I run the following query on the target table.
SELECT * FROM PA0001
WHERE PERNR = '12345678'
I get no results, but PERNR 12345678 is in the source table.
Row counts match on the source and target table. So the data should be there.
Has anyone had this issue before? Any tips on how to find the missing row?