SSIS-948: The checkpoint file ... is already in use by another instance of this package.
– “The data flow component “ComponentName” failed to acquire a connection.” ssis-948
To resolve the SSIS-948 error, follow these step-by-step solutions: SSIS-948: The checkpoint file
Result: The runtime automatically grew buffers to (≈ 9 000 rows) once it detected average row size ~10 KB, cutting the number of I/O calls by ~30 % and halving the overall load time. ssis-948
She added a step before the Derived Column, filtering out rows where both dates are NULL and the order status is not “Shipped”. The new source query became:
An "Adaptive Mapping" toggle in the Flat File Source component.