I have an issue with VS SSDT 2017, SSIS Express Edition. My Source is Oracle 12G and Destination is SQL Server 2017. My package consist of simple Data Load task; Source Connection and Destination connection. And data is coming from SQL script. Using OLE DB connection. Count in source says 238674 rows but SSIS loads and inserts only 144254 rows and there is no any error. Package ends with success (green check marks). Destination table has no issues with types or something. All types and sizes are identical with source. When I delete most of the columns from SQL script and load only 1 or 2 columns it extracts and inserts all 238674 rows. But when there are more columns (8-9 columns), inserted row number is getting smaller.
I was able to solve this issue by this way: 1. Open SSDT as Administrator 2. Use ODBC Source (32bit) for Oracle Source connection 3. Use SQL Server Destination for MSSQL 2017 connection
Everything works fine in this case.