• That would be the simple and very effective way to handle it. I have some flatfiles that are loaded daily and processed through a stored procedure using BULK INSERT. Since the database job calls the procedure, the job notifies us when it fails for any reason. The usual reason is that the creator of the file decided it would be a good idea to add a column without telling anyone, so we see what happened and then tell them to fix their file and resubmit it. Any changes they want to make to the file format we previously agreed to have to go through a process.