By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,382 Members | 1,963 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,382 IT Pros & Developers. It's quick & easy.

DTS permissions and ownership

P: n/a
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
Jul 20 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Managed to find the answer. It was down to a different version of
MDAC.
Ver 2.5 was on the server and 2.6 was on the development PC's. With
the connection properties, additional information is passed with 2.6
which causes a problem with 2.5

When executing the DTS package, it uses the current PC's version. When
scheduled, it uses the version on the server.

The way around this was to re-do the connection properties while
logged on the server (using VNC) and then save it.

Now we know what needs doing, we'll get all of the PC's & servers
checked and put on the same version.

R

ry********@hotmail.com (Ryan) wrote in message news:<78**************************@posting.google. com>...
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

Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.