To clarify
Setting ErrorMode to zero is NOT bad practice, although I could possibly accept that it might not be described as Best Practice.
In my situation, setting the error mode to zero was absolutely essential in order to have the overnight refresh function properly and effectively.
When I answer questions such as these, I don't want to be writing essays on the why's and wherefore's of when to use something, when not to use it and how to protect yourself from the potential dangers. I am assuming when somebody asks how to switch errors off, that they accept and know of the potential areas for problems and will take steps to protect themselves from it (i.e. to produce log files and read those log files to ensure things are working).
In my case, I had over 50 QVW files being refreshed automatically through an SSIS package, I switched error mode off because I didn't want a single failure stopping the whole load process. The SSIS package then read log files to ensure a succesfull refresh had taken place on all files and it sent an email if it found a problem. Works sweet as a nut, did exactly what I wanted it to do, no need to reverse my decision on setting error mode. If I had continued with error mode set to its default value I could potentially have a failure on the first file which stops the whole process because a GUI is then waiting for a response, this means that due to one small failure on one small file, the entire organisation now has no new data and my production issues are a very much higher and more visible problem. In my case, I had one small failure, I know about that failure because I have an email that tells me about it, I can inform the small group using that application that they have no new data but the remainder of the organisation is working as required.
I would also accept that there are other way to achieve the same result, perhaps using Publisher to deal with it, perhaps using 50 different batch files on 50 different schedules, but this was discussed and thrown out as an option in our case.
So, in summary, nobody has (to my knowledge) in this thread suggested that you ignore errors.
