How to change Owner of a package

  • I want to change owner my created packages, because on production my login may not have access.

    I appreciate your quick help.

    Thanks

  • The owner of the package doesn't really matter. I'm not even sure that SSIS packages have owners. What matters is what the protection level of a package is set to and what permissions the logins in the package's connection managers have.

    Greg

  • SSIS packages do have owners. And it does matter who the owner is. It affects security and who can or can't execute the package. Look at db_dtsltduser database role in books online.

Viewing 3 posts - 1 through 2 (of 2 total)

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