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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy