DTS job owner - Urgent

[dbperson]

Hi,

Is there any way to change the owner of DTS package after it has created?

Thanks..

[Mark Kemble]

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..

[Greg]

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..

[Mark Kemble]

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..

[pdougp]

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..

[Vanceulen Kathleen]

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..