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 5:40 pm

    #1397703

    IIRC, when a destination is set to use bulk operations the data loads in batches and any errors cannot be handled individually. You would have to turn off bulk operations, or use transformations prior to the destination load to do your error checking thus guaranteeing only valid data during the load.