I use Data Flow task with Raw file source and OLE DB Destination (mssql table). I found out that during this load I loose most of the data rows, written in raw file.
I used a Row count transformation to look for a raw file number of rows. And I found out that file raw count is always normal (> 1mln rows), but in target table in some executions there is only 50k - 90k rows, but in some cases data loaded normally (>1 mln rows) and matches file rows count.
In addition, when I get small number of rows and reexecute package, which generate this file and load data in destination table - everything is OK, full number of rows is loaded in destination table.
Data access mode = "Table or view - fast load" SSIS 2016
Any ideas? I am confused with nonstatic behaviour of this case :(
The Control flow looks like
