If I have check constraints set to False while loading data and have disabled the index how does that effect the data in the tables when complete? What I'm trying to understand is once the data is loaded with "Check Constraints = false" and say there is data entered that violates a constraint, is this ignored and the bad data stays in the table after the package completes? After the data is loaded I recreate the index. But that still leaves the question on when does the constraints take effect again.