Home Forums Data Warehousing Integration Services Redirect error rows to another table using SSIS RE: Redirect error rows to another table using SSIS

  • October 20, 2011 at 7:31 am

    #1397340

    Thanks. Yes, we have already set it to 'redirect row'. It is currently redirecting rows to the error table, but the issue is that it redirects like a 'batch' of rows. If there is one row that is duplicate/error row, about 6000 or so rows get moved to the error table at a time. Is there a way to elimate that and just move that ONE row to the error table?