The question is where the access denied come from. Is it from logging on to the SQL server or other?
Do you have the source for the exe so you can verify this?
Can't you use the SQL Task?
I don't have the source for the exe.
I can't use the SQL task because it's an executable.
I was reviewing a log generated by Visual Cron and I've seen the following error:
12/29/2010 5:32:38 AM Debug Saving Jobs
12/29/2010 5:39:09 AM Err Task "IMPORT_DAILY" exited with code: 5(Access is denied.)
12/29/2010 5:39:09 AM Err Task "IMPORT_DAILY" exited with code: 5(Access is denied.)
12/29/2010 5:39:09 AM Debug Process status - About to raise TaskCompleted (192)
12/29/2010 5:39:09 AM Info Task completed: IMPORT_DAILY
12/29/2010 5:39:10 AM Info Task started: Error Import WalMart Sul
12/29/2010 5:39:13 AM Info Task completed: Error Import WalMart Sul
12/29/2010 5:39:13 AM Info Job completed: Import Files - Daily
12/29/2010 5:39:43 AM Debug Saving Jobs