Can a file item task correct "overflowed the disk I/O buffer" error

• Resender

  SSCertifiable

  Points: 7443

  More actions

  June 9, 2015 at 8:13 am

  #308911

  ok quick question,

  we have an automated file transfer each night for the past 4 days it failed with "overflowed the disk I/O buffer" on one of the fields in the file

  the files have been moved by the job that does the transfer to the error map,this is done by a file task in the package

  when I run those files through a test enviroment version of the package it gives me 0 errors,both doing in a job or manual from visual studio we receive no errors

  could it be that the move file task corrected the file,since I found out that this can be caused by a coruption in the file

  I have asked the provider to give me an extra copy for the file in a debug map so I can check out if an original files gives this error

• Solomon Rutzky

  SSCoach

  Points: 16430

  More actions

  June 9, 2015 at 4:24 pm

  #1804169

  Hi there. This sounds like an SSIS (Integration Services) question and not a SQLCLR question. If so, there is probably a more appropriate forum that will get this answered much faster.

  SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
  Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
  Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
  Info sites — Collations     •     Module Signing     •     SQLCLR