Results 1 to 3 of 3

Thread: DTS Package ownership issue

  1. #1
    Join Date
    Oct 2005
    Posts
    21

    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

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    1. No.
    2. Shouldn't have any impact, still can run them anywhere. But may unable to edit them if you set owner password.

  3. #3
    Join Date
    Oct 2005
    Posts
    21
    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
  •