Unanswered: Shopping for DTS Package Scheduling Help
First time shopper on this board...hopefully you can help me.
I am trying to figure out how to schedule a DTS package located on a Server to run at a certain time. The DTS package will contain the path to a V/B 6 executable file residing on the same server.
So to test my methodology, I made a package on a server with code to run the V/B 6 executable off of my local machine. When executing the
package manually it works fine. However, when I schedule it the job does not start. I could not find a way to edit the job I had previously scheduled so I made another one in case I "fat fingered" something.
The same thing happens...no job starts.
I'd be inclined to guess that you haven't got SQL installed on the server, or that you don't have the DLL files needed to support DTS on it. My suggestion would be to schedule the job using the SQL Agent, it makes everything so much easier when working with DTS!