copy DTS from a user to another

microsoft.public.sqlserver.programming

25 Nov 2005 3:20 PM

Tarek

Hi,
I have some local packages that are owned by the old sqlserver dba.I'm not
able to see them, nor to save them with my user (i have granted the system
administrator role).
I want to see these packages and move them to a new user.
How can I do this?

Thanks in advance,

25 Nov 2005 3:52 PM

Anith Sen

If you are trying to change the owner of these packages, then you can use
the undocumented procedure, sp_reassign_dtspackageowner.

For details refer to: http://www.sqldts.com/?212
http://support.microsoft.com/?kbid=247052

--
Anith

9 Dec 2005 4:27 PM

Tarek

Hi,
I saved the DTS package as my user but I'm still not able to edit them.
Is it possible that there's a password?
Thanks,
Tarek

Show quote

"Anith Sen" wrote:

> If you are trying to change the owner of these packages, then you can use
> the undocumented procedure, sp_reassign_dtspackageowner.
>
> For details refer to: http://www.sqldts.com/?212
> http://support.microsoft.com/?kbid=247052
>
> --
> Anith
>
>
>