I started a thread a while ago about the fact that if I try to schedule a job with the DTS, the data tries to go to our main server and not on my local machine. If I run the local package manually, the data goes to where I want it to. Lots of people have replied, but I still can't resolve the problem. I want to create a local package that runs as a scheduled job once a week to transfer data from SQL Server tables to Oracle that I have on my machine locally. Anyone got any more suggestions?
This link explains the problem http://support.microsoft.com/?id=269074
When I Double-click the job in Enterprise Manager and then look at the Owner drop-down combo box, it says I am the owner. When I Double-click the job in Enterprise Manager, I can click the General tab, but can't click the Owner drop-down combo box.