March 12, 2010 at 8:26 am
I have a job with a simple dtsrun command that doesn't work.
But if I run it from a command prompt it does work.
The Job is set to write to the application log on failure but it doesn't seem to be doing that. Does anyone know where I can look to find out why exactly it's failing from a sql agent job, but not from a command prompt?
Thanks in advance
March 12, 2010 at 8:59 am
I ran this as sysadmin from qa using xp_cmdshell and got
DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSActiveScriptTask_1
DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220482 (800403FE)
Error string: Error Code: 0
Error Source= Microsoft VBScript runtime error
Error Description: Permission denied
Error on Line 29
Line29 is fso.deletefile(outputfilename)
So that works if I run it from command prompt but not from sql as sysadmin or when I run job with creator the same as creator of package (dbo role)
Any ideas?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply