Im getting the follwoing error when trying to delete a file from a folder when running an ssis package
1073548540:An error occurred with the following error message: "The process cannot access the file because it is being used by another process.".
I put in a task script to put in a delay code was just WAIT FOR DELAY '00:00:45' which seem to work. but now thats stopped working. anyone any ideas of how to fix this issue