SQL Server Performance

Scheduled DTS Package Fails

Discussion in 'SQL Server DTS-Related Questions' started by acasselman, Oct 30, 2007.

  1. acasselman New Member

    I'm having some trouble getting some scheduled packages to run. I have created a package (SQL Server EP 2000) to pick up the most recent flat file in a folder and import it into a table. I can run the package manually just fine, and I can manually execute the job, but it always fails when it tries to run on schedule.
    Could this have anything to do with the fact that it lists my NT account as the owner (it won't let me change that)? Any other ideas?
  2. martins New Member

    Hi,
    It doesn't have anything to do with the owner, but with the account the SQL Agent service runs as. Check your services and make sure the SQL Agent account have the appropriate rights on the server you are trying to import the files from.

Share This Page