Post reply

The process cannot access the file because it is being used by another process.

  • August 24, 2006 at 10:57 am

    #153149

     

    I have a File System Task Copy file operation to copy a file in an SSIS package.  The package when scheduled as a job fails with the following error:

    The process cannot access the file 'C:\ETL\Consignment\Apple\AppleRawFile.txt' because it is being used by another process.".

    However when I right click on the package and execute it manually from the Integration Services it runs successfully without any problem.  I am not certain on how to resolve this issue any inputs will be much appreciated.

    Thanks,

    Monisha

  • August 26, 2006 at 4:57 pm

    #657008

    Is your package itself holding a lock on that file by any chance?


    paul

  • July 7, 2010 at 12:10 pm

    #1189785

    Hello -

    I am getting this same message when a maintenance plan runs the backup jobs. To me it appears that the process (the Maintenance Plan) that creates the .txt file is the same process that is trying to access the file - like it is locking the file preventing itself from accessing the file. Is there a solution for this? The backup jobs do finish successfully.

    Thanks!

    db

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

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