This is the error i am getting when i am executing the package through DTloggedexec.
"The process cannot access the file because it is used by another process"
i came to know that the log created by DTloggedexec is used by the other process. the package didnt fail for this error in the job it shows that it running successfully. this caused a severe issue.
but no process has happened.
I have changed the log file name and it is executing. what is the problem.? why the job doesnot fail.?