SSIS: Not able to rename package

  • Dear all,

    I have a problem when trying to rename a package name. I get this message even knowing that the package is not there (on my workspeace).

    "Cannot complete the operation. You are attempting to move or modify a source controled where an item of the same name already exists. The item is exclusived locked somewhere "

    I have delete the previous file that I had in : C:\Users\eperi\Source\Workspaces\itScrum2\main\source\dwh\source\ETL\dwhSourceToStaging   So I don't have any file there.

    Thank you for your support.

  • river1 - Wednesday, October 4, 2017 3:34 AM

    Dear all,

    I have a problem when trying to rename a package name. I get this message even knowing that the package is not there (on my workspeace).

    "Cannot complete the operation. You are attempting to move or modify a source controled where an item of the same name already exists. The item is exclusived locked somewhere "

    I have delete the previous file that I had in : C:\Users\eperi\Source\Workspaces\itScrum2\main\source\dwh\source\ETL\dwhSourceToStaging   So I don't have any file there.

    Thank you for your support.

    The "problem" is your Source Control. Either a file of the same name exists in your Source Control Environment (thus would mean that when you commit the files couldn't be merged), or the file you're trying to rename is locked by another user, thus you don't have write permissions to your copy and cannot rename it.

    I don't know what Source Control software you're using, but the error is implying one of the above reasons. You'll need to check your Source Control and see what one is applicable.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • river1 - Wednesday, October 4, 2017 3:34 AM

    Dear all,

    I have a problem when trying to rename a package name. I get this message even knowing that the package is not there (on my workspeace).

    "Cannot complete the operation. You are attempting to move or modify a source controled where an item of the same name already exists. The item is exclusived locked somewhere "

    I have delete the previous file that I had in : C:\Users\eperi\Source\Workspaces\itScrum2\main\source\dwh\source\ETL\dwhSourceToStaging   So I don't have any file there.

    Thank you for your support.

    Which VCS are you using?
    To delete an existing package, removing it using WIndows Explorer is not sufficient; it should be deleted from its containing solution from within SSDT. You may need to check in the deletion before you can reuse the name of the deleted package (depends on VCS).
    Please verify (using Explorer) that the deleted package has definitely been removed from the above path.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • its TFS. Yes. I have tried to delete from SSDT and from my workspace. then checkin. Then bring last version from the server . then create a new package with the same name but unfortunately same error appears. I don't think its user related as no one is using this package we are just a team of 3 some I am aware...

    Don't know what more to do...

  • river1 - Wednesday, October 4, 2017 5:36 AM

    its TFS. Yes. I have tried to delete from SSDT and from my workspace. then checkin. Then bring last version from the server . then create a new package with the same name but unfortunately same error appears. I don't think its user related as no one is using this package we are just a team of 3 some I am aware...

    Don't know what more to do...

    Check to be sure you don't have any "Pending Changes".   If that's not a part of the problem, then do a "Get Latest Version" at a level well above where your file is located in your workspace.   If that fails to resolve it, then re-boot and try it again, but from the very highest level of your source control.   Something may well be out of sync between your workspace and TFS.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

  • river1 - Wednesday, October 4, 2017 5:36 AM

    its TFS. Yes. I have tried to delete from SSDT and from my workspace. then checkin. Then bring last version from the server . then create a new package with the same name but unfortunately same error appears. I don't think its user related as no one is using this package we are just a team of 3 some I am aware...

    Don't know what more to do...

    Do a search across all folders on your file system for files with the offending file name. Does it exist somewhere else and, if so, could TFS be complaining about the other version?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Viewing 6 posts - 1 through 5 (of 5 total)

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