I'm calling a child package in a for each loop from the parent, the child loads data from a flat file then returns to the parent. Back inside the parent, I want to delete the file we've just loaded but I get this error... And it's doing my nut in!
An error occurred with the following error message: "The process cannot access the file "c:\YourStupidFile.txt" because it is being used by another process.".
I've tried putting wait times in a script task but to no avail. Any help would be awesome.