Post reply

SSIS package failed when running in debug mode

  • September 2, 2009 at 9:57 am

    #135826

    Hi,

    When I try to run a SSIS package that call another one, I am getting "The process cannot access the file because it is being used by another process.".

    I am sure I am the only one on the box that no one are using the package. Does someone already had the same issue? Do you know a workaround to fix this?

    Thanks

  • September 23, 2009 at 6:11 pm

    #1057826

    Hi,

    I am still having issue with this. I just hope I am not the only one having this kind of problem.

    Does someone have an idea on how to fix this?

    Thanks,

  • October 20, 2009 at 11:00 am

    #1068354

    I am the only one having this issue?:unsure:

    Please I need to help....

    Thanks,

    Rem

  • October 20, 2009 at 11:55 am

    #1068404

    Is the package load returning that or while it is running? Is the package you are trying to load in the same solution you are running? Are you sure the package isn't opened anywhere else?

    Edit: Also, are you using Excel source/destination in the child package?

    CEWII

  • October 21, 2009 at 4:31 am

    #1068746

    Also verify that this package is not called by two Execute Package Tasks at the same time. It might be that you are using more than one Execute Package Task and both are using the same connection and trying to execute this package at the same time.

    --Siddharth

  • October 22, 2009 at 8:31 am

    #1069465

    HI,

    Thanks for answering. Actually the child package is not running anywhere else when I am getting this error. Can this be an issue with the Package ID?

    Rem

  • October 22, 2009 at 1:59 pm

    #1069645

    Can you send a screen print of the control flow of your package?

    CEWII

  • October 26, 2009 at 7:20 am

    #1070674

    Hi,

    You will find attached the print screen on the control flow. This is a very basic package.. The package are located on a filesystem and have for protectionLevel "EncryptSensitiveWithPassowrd".

    Everything work fine when call via the SQLAgent, but the when I want to run the package via the debug mode, it failed on the second package call.

    This use to works without problems for months.

    Thanks for your help.

    Rem

  • October 27, 2009 at 9:42 am

    #1071301

    I agree that is pretty straightforward. You say that the "Rebuilt Product" works fine but the "Load Goal" dies?

    Questions:

    1. Are those two packages in the same location on disk?

    2. Do they each have the same file security on them, you can find out by right clicking on the DTSX file and going to properties, security tab.

    3. What is in the output when it dies?

    CEWII

  • October 27, 2009 at 2:24 pm

    #1071445

    First can you post an entire copy of the output execution from a failed execution. For troubleshooting I would run each package individually from within the IDE. The output messages should give insight of whats going on.

  • November 4, 2009 at 2:36 pm

    #1075052

    The message is:

    Error: Error 0x80070020 while loading package file "D:\Packages\LOAD Goal.dtsx". The process cannot access the file because it is being used by another process. .

    This is happening to a few child packags.

    Thanks for your help

    Rem

  • November 4, 2009 at 2:48 pm

    #1075060

    Are you using transactions? Make sure there are no expressions behind te scenes that could be pointing at the same package. Did you run the tasks manually one at a time in the IDE? What happened. Make sure the source and destinations in your data flow have the evaluate metadata property set to false. These are the best suggestions I can give you without seeing the package.

  • November 4, 2009 at 2:54 pm

    #1075063

    You have made a statement without asking a question, leaving us to guess.

    Are you saying that the problem does not happen unless you are in debug mode, or is it just a coincidence?

    How complex is the package in terms of numbers of components? Are there multiple script tasks? Where are the breakpoints set?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • November 6, 2009 at 5:44 am

    #1075854

    Thanks all for you help.

    The package is very very simple. I have already posted the print screen of control flow.

    Then I try to run the child package for the first time, it failed at the first execution. But if I try to rerun the child package after the first failure, it works. I am totally confuse.

    This problem occurs on a few other packages. If it because the location of my package are on a file system? Is it something related to ID of my packages?

    When this happen, I am the only one on the box I am can confirm that not others packages are running.

    Thanks all for your help,

    Rem

  • November 6, 2009 at 6:28 am

    #1075867

    Generate New IDs for all your packages.

Viewing 15 posts - 1 through 15 (of 33 total)

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