• 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