仙仙熊SQL筆記: SQL Server data collection with error code -1071636372 and -1073450952

env: Windows Server 2016
SQL Server 2016 SP2

很不幸Data Collection出現錯誤，這次錯誤訊息如下:

Executed as user: XXXX\XXXX. SSIS error. Component name: DFT - Upload collection snapshot, Code: -1071636372, Subcomponent: RFS - Read Current Upload Data [138], Description: String too long. The adapter read a string that was 256 bytes long, and expected a string no longer than 129 bytes, at offset 100587. This could indicate a damaged input file. The file shows a string length that is too large for the buffer column. . SSIS error. Component name: DFT - Upload collection snapshot, Code: -1073450952, Subcomponent: SSIS.Pipeline, Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on RFS - Read Current Upload Data returned error code 0x80004005. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure. .The master package exited with error, previous error messages should explain the cause. Process Exit Code 5. The step failed.