Home Forums SQL Server 2005 Business Intelligence SSIS File Rename - The process cannot access the file because it is being used by another process RE: SSIS File Rename - The process cannot access the file because it is being used by another process

  • August 29, 2014 at 10:09 am

    #1741977

    OK thanks.

    1) How would I Pause/break the SSIS package at the specific time to see what has the files open? In the middle of the Foreach file enumerator? Or right after that data flow task, and how?

    2) If I find SSIS has the files open, how do I solve this and tell SSIS to close them? Is the only solution to have multiple, separate packages?

    Goodness, this was so much easier in 100% VBA.