How can I inform myself that an automatic SQL Server process has worked?
count lines/records in your textfile
import
count records after import
if count1=count2 then continue
tidy up fields  (update blablabla set changefield='new' where myfield='badinfo')
test tidy up :  select count(*) from blablabla where myfield='badinfo' and changefield&lt;>'new'
if testTidyUp-count = 0 then cleanup = correct ... continue
count records after tidy up
export to production
count records in production
if count3=count4 then ... let mysql know all is 'ok'


All the else ... mail that something is wrong