Date parsed: 18/10/2007 22:47:58
Date: 19 Oct 2007 05:47:58 -0700

Hi,

I am having a difficult time finding out how to give users DTS
permissions on SQL 2005.

They were originally created on SQL 2000 with a user who had SA
permissions. Now, the users can look at them, but not save any
changes. I have tried giving permissions to the table sysdtspackages
as well as these procs: sp_add_dtspackage, sp_enum_dtspackages, and
sp_get_dtspackage but the developer is still getting this error: "Only
the owner of a dts package or sysadmin can create new versions". I
don't want to have to make the developer sysadmim nor do I want to
have to migrate DTS from a development server as we have too many hard-
coded connections that I would have to change. This developer needs to
make little changes....

I am hoping one of you has been through this before and can point me
in the right direction.

Thanks!
Kristina