We have a DTS package developed on our development PC's (SQL 7). It
runs fine. When we schedule it on the server (SQL 7), it fails. We
have been able to find that this is a known issue down to the use of
permissions (running it uses the users permissions, scheduling it uses
the servers). http://support.microsoft.com/?kbid=269074
Our Ops Support team insist that we have the full permissions to run
this, but it still fails. If we log on to the server as the service
and re-create (sample) the DTS package, we can schedule it. However,
we don't want to have to go the the comms room (or use VNC) to develop
DTS packages. If we then change this on our development PC's we get
the same problem as we appear to have taken ownership. It looks like
ownership is not just on the DTS package, but on the components as
well.
Is there are way of changing the ownership of the DTS package /
components ?
What can I check with regards permissions ?
Any help would be appreciated.
Thanks
Ryan