Post reply

SSIS job error

  • June 1, 2011 at 4:53 am

    #148113

    Hello,

    I get an error while trying to run an SIS package:

    --------------------------------------------------------------

    Thread "WorkThread0" has exited with error code 0xC0209029. There may be error messages posted before this with more information on why the thread has exited. End Error Error: 2011-06-01 11:45:50.90 Code: 0xC02020C4 Source: Update Booking Gapp Booking [1] Description: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020. End Error Error: 2011-06-01 11:45:50.95 Code: 0xC0047038 Source: Update Booking Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "Gapp Booking" (1) 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. End Error Error: 2011-... The package execution fa... The step failed.

    ---------------------------------------------------------------

    The error comes up at the data flow task when it tries to run the query from a variable:

    SELECT distinct bk.* FROM booking bk

    inner join keu_book_tmpU kbt

    on bk.booking_id = kbt.booking_id

    Could someone please help me in this regard ?

    Thanks and Regards,.

    Paul

  • June 1, 2011 at 11:26 am

    #1332650

    Google is your friend in this case:

    I searched for "The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020" and the first result I'm getting is a link to http://www.sqlservercentral.com/Forums/Topic300907-148-1.aspx#bm872507.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • June 2, 2011 at 1:56 am

    #1332934

    LutzM (6/1/2011)

    Google is your friend in this case:

    I searched for "The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020" and the first result I'm getting is a link to http://www.sqlservercentral.com/Forums/Topic300907-148-1.aspx#bm872507.

    Hi Lutz,

    Thanks for your response. Actually I have been trying google since yesterday but all in vain. The thing is the error I am getting is very generalized and does not indicate any particular cause and so I am lost.

    Regards,

    Paul

  • June 2, 2011 at 2:28 am

    #1332947

    Straight from the link I posted before:

    option 1:

    changing the 'table or view fast load' to 'table or view' mode

    option 2:

    Make sure to check your source and destination steps that may be trying to copy a view to a view.

    Also, the following links do provide some other possible reasons:

    http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/4139472b-8d25-41a9-a68b-828933886c11/

    http://www.sqldev.org/sql-server-integration-services/data-flow-task-buffer-failed-4912.shtml


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

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

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