ms-techie (3/12/2014)
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
If it works sometimes it means, the solution is correct. Only the timing might be a problem.
Check if there is any input\output file (flatfile, log file ..) that's being shared at the same time ? Or may be someone is opening the file and not closing it which makes the package to fail ..
--
SQLBuddy