Scheduling a DTS to run as a job
Hello. I have no real training on SQL but I have managed to create a DTS
using the wizard to accomplish what I want to occur:
I have a query that produces a file. The DTS sends the file to a different
server which picks up the file for an interface. That part works.
My problem is I want to schedule the DTS to run as a job. I go through all
the steps on the wizard and it looks great, but the first time it runs it
fails with only a cryptic -"failed at step one". Step one is to execute
the DTS and query that works just fine when I manually execute it. The scheduling
works because it runs, and fails, every hour on the hour.
I have also tried just right clicking on the DTS, going to scheduling and
trying to "schedule" it from there, but it won't save my changes and reverts
back to not being scheduled.
I am sure I'm missing something fundamental, but if the DTS works successfully
shouldn't I just be able to schedule it to run as a job??
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL