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.

  • October 20, 2011 at 11:17 am

    #1397547

    In my case the problem was only on the items in the data flow task where the "[highlight=#ffff11]Check Constraints[/highlight]" option was selected for the OLE DB Destination. Once I change that, i had no issues. In my case I did not want the check, but your case might be different.

    Regards,

    Derald