SSIS Child package file locking issue

  • 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.

    Cheers

  • chris.rogers00 (3/28/2013)


    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.

    I haven't tried to have a parent package delete a file generated from a child package. But I do have child packages delete their own files when finished. Any chance that your child package could delete the file as the final step in the process?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply