Post reply

File System Task -- Error during Copy

  • June 16, 2010 at 11:51 am

    #147508

    In my SSIS Package I have file location path set in a Variable.

    where i run the File System task suing the setting as Variable then it gives me the following message

    [File System Task] Error: An error occurred with the following error message:

    "The process cannot access the file 'C:\Folder\File.txt' because it is being used by another process.".

    If i set a Flat file connection it works fine. I see no process accessing the file.

  • June 16, 2010 at 12:03 pm

    #1181214

    I got it.. I was setting checkpoint on the job which failed. When it failed I renamed the file name and tried to re-run the packgae. Because in Checkpint.xml file the values are already persisted so it was not taking new values and was crashing .

    It works now

    Thanks

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

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