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 Development (2000)  SQL Server DTS package fails when scheduled

Author  Topic  rpress Starting Member 2 Posts Posted - 2001-08-09 : 14:01:41 HI - I have built a DTS package that runs fine when fired manually, but fails when scheduled as a job. The package takes a pipe delimited text file and loads it into a table. The SQL Server Agent Service is using a local account, but the source data is on the same box as the database, so I shouldn't need to use a domain account, right? The permissions of the directory where the data files are stored has the permissions set to full control for everybody. I have also copied the DTS package while on the server to make the local server account the owner of the package, but this has not helped. Someone on another list suggested that I grant the account that the agent runs under privs to the package. Does anyone know how to grant the agent account priveleges? Any ideas why the package is failing when scheduled? Thanks