Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 DTS Job

Author  Topic 

ladiaocb
Yak Posting Veteran

57 Posts

Posted - 2006-09-02 : 12:07:47
I have a strange problem. When I go to run a DTS package interactively it works fine. However, when the DTS package is run via a job, it fails. I thought it was a permissions issue at first. But I ran it with an ID that has admin rights and it was still a no go. Any help is greatly appreciated.

Marin
Starting Member

4 Posts

Posted - 2006-09-03 : 01:45:58
Check the account under your SQL Agent service is running.

_______________________________________
Check Website Hosting and Development (website-hosting-development.com) site by DIMM Info Systems Inc. (dimm-is.com) for articles about website hosting, development, design and database tutorials and guidelines.
Go to Top of Page
   

- Advertisement -