Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Problem with Data collection jobs on one server. Expand / Collapse
Author
Message
Posted Sunday, October 07, 2012 4:19 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Sunday, December 08, 2013 10:48 PM
Points: 31, Visits: 124
Hi, I have a problem with one server and the default data collection job failing.

If someone could help that would be great!

collection_set_3_upload job is failing on step 2.

Message
Executed as user: mydomain\myuser. SSIS error. Component name: DFT - Upload collection snapshot, Code: -1071636372, Subcomponent: RFS - Read Current Upload Data [1], Description: String too long. The adapter read a string that was 620762624 bytes long, and expected a string no longer than 129 bytes, at offset 60974. 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 component "RFS - Read Current Upload Data" (1) 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.
Post #1369580
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse