September 14, 2010 at 7:15 am
[INSERT GENERAL 1 [10387]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80004005 Description: "Unspecified error".
[INSERT GENERAL 1 [10387]] Error: There was an error with input column "HRGNHS" (10435) on input "OLE DB Destination Input" (10400). The column status returned was: "The status value given to the provider was not valid.".
[INSERT GENERAL 1 [10387]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "input "OLE DB Destination Input" (10400)" failed because error code 0xC020907B occurred, and the error row disposition on "input "OLE DB Destination Input" (10400)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "INSERT GENERAL 1" (10387) failed with error code 0xC0209029 while processing input "OLE DB Destination Input" (10400). 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.
[GET APC DATA [9524]] Error: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020.
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "GET APC DATA" (9524) returned error code 0xC02020C4. 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.
[Unpivot Diagnosis 1 [10089]] Error: Failure when trying to pivot the source records.
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Unpivot Diagnosis 1" (10089) failed with error code 0xC020208F while processing input "Unpivot Input" (10090). 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.
See above for actual errors.
Basically, I'm stumped. This error occurs when I change a data-source column to length 5 from length 3. I've gone through the entire dataflow, long past where the errors occur and made the length of this data item 5. I've also updated the database to allow length 5.
I've tried adding a data-viewer to the flat-file source and found that it still fails but the data is all fine - and the unpivot now succeeds, see below for errors.
[INSERT GENERAL 1 [10387]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80004005 Description: "Unspecified error".
[INSERT GENERAL 1 [10387]] Error: There was an error with input column "HRGNHS" (10435) on input "OLE DB Destination Input" (10400). The column status returned was: "The status value given to the provider was not valid.".
[INSERT GENERAL 1 [10387]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "input "OLE DB Destination Input" (10400)" failed because error code 0xC020907B occurred, and the error row disposition on "input "OLE DB Destination Input" (10400)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "INSERT GENERAL 1" (10387) failed with error code 0xC0209029 while processing input "OLE DB Destination Input" (10400). 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.
[GET APC DATA [9524]] Error: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020.
[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "GET APC DATA" (9524) returned error code 0xC02020C4. 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.
What's annoying is that if I set the length back to 3 in the file source, the data is truncated to 3 but the whole package executes with no problems. I'm at a loss for what else to check, so any suggestions would be greatly appreciated.
September 14, 2010 at 8:44 am
Added an error destination file.
Below are a few of the codes that successfully were input into the DB: -
PA24Z
MC03Z
FZ07B
NZ05A
WA22X
DZ21H
FZ03A
FZ03A
Now here are a few that failed and were instead redirected : -
HD36A
JD01A
EB04H
WA03X
UZ01Z
UZ01Z
UZ01Z
UZ01Z
EB08H
FZ38C
EB11Z
WA22X
AA29Z
SA13Z
HA94Z
Many more were accepted (1,136,129 rows) rather than rejected (353,078 rows), but I don't understand why any were rejected
September 14, 2010 at 9:36 am
Resolved.
Unsure why this worked, but here was the solution -
The data-flow was multi-cast between 5 different tasks. All except the second one were green. Turns out the error was in one of the green tasks, a mapping mistake of mine. Lots of fun.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply