February 22, 2012 at 6:47 pm
Hi There,
We have a couple of developers working on some SSIS projects on a development server. They both log in with different AD accounts. We are finding that if a developer opens up an exising package created by another user, they can not save over the top. When trying to it comes up with the error 'The operation could not be completed'.
I am guessing this is a permission issue but not sure how to get around it. Can two people not work on the same project? Just to be clear, they are not trying to access it at the same time.
We are trying the TFS approach now to see if that resolves the issue, but any tips would be appreciated.
Thanks. -- ooops just noticed I posted in the wrong from. Can this be moved?
February 23, 2012 at 5:29 pm
I'm kind of guessing as I've not worked much with SSIS yet... but in the olden days of DTS, the package ownership was assigned to whoever created it, and you had to be an owner to modify packages.
Here is a site with some hints on changing ownership:
http://sqltidbits.com/scripts/change-maintenance-plan-owner-change-ssis-package-owner
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply