Home Forums SQL Server 2005 SQL Server 2005 Integration Services The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020. RE: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020.

  • January 20, 2008 at 5:22 pm

    #770022

    This is not a solution but another example of the same error.

    I'm writing a package that compares two tables of the same name in different databases. If the data exists in both tables I want to update the destination table with changes from the source table.

    If the data does not exist in the destination table, I want to insert it. I've written a query to select the correct data (SSIS Lookup Query.jpg) and tested that it works (SSIS Lookup Preview.jpg).

    I'm new to this so I don't know whether the lookup should be a SELECT or UPDATE but other than that I would have thought this should work?