Applies to

SSIS

Description

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.

Resolved by

DBAs, Server administrators, ETL developers

Suggested solutions

1. Set FastParse Option on the Flat File Source
2. Baseline source system extract speed by creating a very simple package reading data from your source with the destination of “Row Count”
3. Try to perform your data flows in bulk mode instead of row by row
4. Add more physical memory to the computer

Additional research

SSIS: Performance Counter
SSIS Pipeline Performance Counters Guide
Introduction to BLOB data types in SSIS: Part 1

⇐ Back to index