SQL Server 7.0 SP4
I guess most of are aware that ownership between creating
and executing a DTS package as opposed to scheduling the
same, are different especially when you create the DTS
package on a SQL Server that's not local.
I have a server to which I don't have physical or even
remote access to (PC Anywhere, VNC, etc). I've created a
DTS package on this server via my Enterprise Manager. I've
also been able to run this package successfully. The owner
of this package is picked up from my machine
When I schedule this package, I see that the owner is 'sa'
causing the job to fail.
Without actually being on the server either physically or
remotely, I was wondering if there's a way to have this
package scheduled to run as a job.
Your responses and suggestions are highly appreciated.