SSIS The process cannot access the file 'ssisproject.ispac' because it is being used by another process

  • Hi

    I understand this is no the ideal way to use SSIS but here is what I have to do if possible.

    I have two packages in one ssis solution. I have to run one package in visual studio 2010 shell, which runs file but will take a long time. I would like to open another instance of VS2010 and work on and run the other package in the same solution.

    I get the error The process cannot access the file 'ssisproject.ispac' because it is being used by another process

    It makes sense that this happens but I was wondering if there was some trick or workaround to allow me to do this. The only workarounds I can think of are either to create a separate workspace for the same solution or create another solution, both of which are not desirable. Is there something easy, such as a setting to access the ispac file in shared mode?

  • I'm not sure that I understand why you're doing this, but you could make a copy of the project folder. Run one instance from the original folder and another instance from the copied folder.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

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

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