Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: GoodZamboni
- Order by date
-
Server Agent wont run DTS jobs
I know the package won't run because it says "Failed" under job status in SQL Server Agent. The job runs under DTS. Other jobs created through SQL Agent work. However, the job that works in DTS (when I press play), won't work when scheduled. SQL Server agent will try to run it, but...- GoodZamboni
- Post #3
- Forum: Microsoft SQL Server: Data Transformation Services
-
Server Agent wont run DTS jobs
Sql Server agent won't run any of my DTS jobs. The DTS job is just a tester--a blank console app. If I run the job in the DTS manager, it works fine, but Sql server agent won't run it. I've clicked throught the properties and nothing seems out of line. For the package I'm talking about, it has...- GoodZamboni
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Data Transformation Services
