Row Count task in data flow fails with "unspecified error"

• Gergely Mészáros

  SSC-Addicted

  Points: 454

  More actions

  July 25, 2025 at 1:08 pm

  #4627016

  Hi all,

  I have a data flow task with:

  Flat File Source (csv) -> Conditional Split -> Row Count -> Data Conversion -> Destination (OleDB)

  Everything works in development environment, on development server, UAT server. On production it fails with the following:

  "Process file:Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Transaction record count" (2331) failed with error code 0x80004005 while processing input "Row Count Input 1" (2333). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.

  Process file:Error: Unspecified error"

  No more information, the SSIS build verion is the same on all environments. The error appeared a few days ago, it was working for years.

  Any idea?

  Thanks,

  Gergely

  • This topic was modified 2 months ago by Gergely Mészáros.

• Site Owners

  SSC Guru

  Points: 80382

  More actions

  July 26, 2025 at 1:10 pm

  #4627305

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.