July 29, 2010 at 10:37 am
Good morning-
I recently inherited a package that does numerous things. One of the steps uses Robocopy to copy a large output file to another server for further processing. The next step then renames that file in preparation for archiving it elsewhere. The last two weeks the package has failed with the same error on the Rename file step (cannot access file x as it is being used by another process). This is, at the very least, annoying.
Apart from moving things around, does anyone have any suggestions?
Thanks,
Jason
July 30, 2010 at 8:37 am
You may check which process is using that file using Process Explorer. Also you can add a WAIT/SLEEP value so that there is delay between robocopy and copy file process.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
July 30, 2010 at 8:53 am
Instead of using a File System task, use a script task containing appropriate code. It works much better, in my experience and requires just three or four lines of code.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply