-
DTS job owner - Urgent
Hi,
Is there any way to change the owner of DTS package after it has created?
Thanks..
-
DTS job owner - Urgent (reply)
Nope . . . check out BOL for more info
------------
dbperson at 8/17/01 10:02:52 AM
Hi,
Is there any way to change the owner of DTS package after it has created?
Thanks..
-
DTS job owner - Urgent (reply)
Try this....
With the DTS package open click Package | Save As.
Change the "Location" to "File" - changing owner and user passwords as required - effectively saving it externally to SQL Server. Close the DTS package.
If you log back on a s the new user of the the package, open the DTS file and save it to Location = SQL Server that should do it.
Haven't tried this but it seems to make sense.
------------
Mark Kemble at 8/17/01 10:58:58 AM
Nope . . . check out BOL for more info
------------
dbperson at 8/17/01 10:02:52 AM
Hi,
Is there any way to change the owner of DTS package after it has created?
Thanks..
-
DTS job owner - Urgent (reply)
That doesn't work . . . you can't change ownership of a package once it's been created, even if you try saving it to another name, location, type, user, etc... Nice feature, huh?
------------
Greg at 8/17/01 11:19:58 AM
Try this....
With the DTS package open click Package | Save As.
Change the "Location" to "File" - changing owner and user passwords as required - effectively saving it externally to SQL Server. Close the DTS package.
If you log back on a s the new user of the the package, open the DTS file and save it to Location = SQL Server that should do it.
Haven't tried this but it seems to make sense.
------------
Mark Kemble at 8/17/01 10:58:58 AM
Nope . . . check out BOL for more info
------------
dbperson at 8/17/01 10:02:52 AM
Hi,
Is there any way to change the owner of DTS package after it has created?
Thanks..
-
DTS job owner - Urgent (reply)
Try:
sp_reassign_dtspackageowner 'package name',
'id' (from sysdtspackages),
'domain/ownername'
I've had success using it before.
------------
dbperson at 8/17/01 10:02:52 AM
Hi,
Is there any way to change the owner of DTS package after it has created?
Thanks..
-
DTS job owner - Urgent (reply)
Hello,
I have tried the 'sp_reassign_dtspackageowner' and it works +-.
BUT somethings strange happens.
I change de owner fom AAAAA to BBBBB.
BBBB can open the DTS, make changes and save it again. ( great !!!)
After BBBB has saved his changes the owner of the DTS is back AAAA in the Enterprise Manager.
But BBBB stil has his rights on this DTS-package ?
Is this a BUG or do I have to make some changes somewhere else ??
------------
pdougp at 9/10/01 12:52:34 PM
Try:
sp_reassign_dtspackageowner 'package name',
'id' (from sysdtspackages),
'domain/ownername'
I've had success using it before.
------------
dbperson at 8/17/01 10:02:52 AM
Hi,
Is there any way to change the owner of DTS package after it has created?
Thanks..
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
|
|