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 28, 2016 at 7:56 am

    #1909358

    I had the same problem and tried all mentioned methods but all failed. At the end, I realised that the source column size was exceeding the size of the item in conversion component. After setting them equal, the problem had beeen solved.