Hello
I've just been setting up a DTS job in VS integration services.
I'm now trying to save the package to a SQl server 2005 on another machine.
I am able to access the package location but when I try to access the package path I get the error
' the execute permission was denied on the object sp_dts_listpackages'
I've looked at the permission on the other SQL machine but cannot see where to resolve this.
Does anyone know how to resolve this.
Thanks
Start Free Trial
