Thanks Jason, I am going to investigate that option a bit further. It seems to make a lot of sense as it involved only hitting the record once (when it is created)

My concern is that all 20 files need to load with the same FROM date even if the load runs over midnight (I have no idea when it will be run or how long it will take on the production server) and although I can use standard CASE WHEN THEN END logic to roll the date back if we go over midnight, I really want to be able to set the default from a variable value (which you obviously can't do because then it wouldnt be a default :w00t:)

The Bulk Insert script is called 20 times from an SSIS package and the From Date would be the package start date