Ssis-668
Ensure that the .NET Framework version is compatible with the package. You can do this by:
In Script Components, at ProcessInputRow or PreExecute, verify buffer has rows before accessing fields; e.g. check RowCountVar or use HasRows logic.
Run package with source returning rows — observe success.
Modify source to return zero rows — run package and observe failure or exception.
Capture package log (SSIS logging) and error message.
When a data flow task receives zero rows from an upstream source (e.g., filtered source or empty lookup result), downstream components intermittently throw a null-reference or unexpected-rows error causing the package to fail. Symptoms include: SSIS-668