Phil Parkin (10/24/2014)
Then I am running out of ideas. Problems like this are tough to debug.You could try running the job in 32-bit mode (which is how it would have run in BIDS). Though I cannot see why that would help.
If that does not help, you could consider adding some sort of logging to the script to enable you to determine exactly which line is causing the issues.
hmm. I'll try the idea of running the job in 32 bit mode. maybe it can help.
I also feel confuse because this is a revision script. the older script has some more file to be attached and now I delete that part of script. Before I changed it, everything is running well. I have other 5 scripts like this (use to search file to be attached as email attachement) 3 of them is running well. There are 2 (including this one) that have the problem.
logging script? like writing to database or file to make sure that the script is running?