Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS Child package file locking issue Expand / Collapse
Author
Message
Posted Thursday, March 28, 2013 4:34 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, June 16, 2014 10:29 AM
Points: 73, Visits: 154
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
Post #1436373
Posted Thursday, March 28, 2013 9:28 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 11:36 AM
Points: 493, Visits: 1,867
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?
Post #1436552
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse