Ssis Check For File Lock Download
Ssis Check For File Lock Key
I currently have an SSIS package which runs a foreach loop around a folder and stores rows from in a number of Excel worksheets into a database. This works just fine.Outside the loop, I then have a foreach loop which follows to move the processed files into another folder. When it reaches this point, I get an error ofThe process cannot access the filebecause it is being used by anotherprocess.I've tried putting in a 10 second delay step, but that still isn't helping. Is there any way around this?