-
DTS Package ownership issue
Hi
In production, I have couple of DTS packages saved under the ownership of the old dba(her network id). All the new DTS packages have my network authentication id as the ownership.
I read an article in the sqldts.com saying, this will not affect the day to day activities. Link below
http://www.sqldts.com/default.aspx?212
My questions
1) Is there anyway I can create the DTS package with an sql authentication id (sa) instead of the my windows authentication id.This will clear off the issue of person specific ownership for the dts package.
2) I am aware of the undocumented stored procedure
sp_reassign_dtspackageowner to change the owner name.Incase i am changing it for all the packages in the server, what will be the impact?
Most of the dts packages are run using the jobs and i assume there wont be any problem with that.
what about the packages directly invoked using the applicaiton?
Thanks in advance
Sreenath
-
1. No.
2. Shouldn't have any impact, still can run them anywhere. But may unable to edit them if you set owner password.
-
Thanks rmiao for confirming, even i was thinking that we wont be able to create the package with sa as the owner.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|