The data flow engine is largely about the transfer of rows from source to destination.
This performance counter keeps track of total number of input rows that have been read from source adapters excluding reference sources such as the Lookup transformation. Because this counter tracks all rows read since the restart of the service, you should expect the value of this counter to be very high.
DBAs, Server administrators, ETL developers
- Set FastParse Option on the Flat File Source
- Baseline source system extract speed by creating a very simple package reading data from your source with the destination of “Row Count”
- Try to perform your data flows in bulk mode instead of row by row
- Add more physical memory to the computer
SSIS: Performance Counter
SSIS Pipeline Performance Counters Guide
Introduction to BLOB data types in SSIS: Part 1