SSIS Execution 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.

    [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.


    Forever trying to learn
    My blog - http://www.cadavre.co.uk/
    For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
    For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • 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


    Forever trying to learn
    My blog - http://www.cadavre.co.uk/
    For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
    For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • 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.


    Forever trying to learn
    My blog - http://www.cadavre.co.uk/
    For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
    For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply