It works and sometimes fails , without any change in the code .
The error message is as below
We inoke the SSIS package via the DTExec.exe
DTExec /File "\\Server1\SSISPackage1.dtsx"
/ConfigFile "\\Server1\MyConfig.dtsConfig" 1>output2.log
The process cannot access the file because it is being used by another process.
When I checked via process explorer if the SSISPackage1.dtsx and MyConfig.dtsConfig , it shows 0 handles , which means to say these files are not used.
When I Kill the DTExec process from the windows task manager on the server1 , it starts working again . What could have gone wrong in this case