I have created a DTS package. Now I have schedule the package to run under
the SQL Server scheduler. When I execute the package manually, it runs just
fine. When I run the job from the scheduler it fails. Below is the complete
error message. The package is simple. It opens a text file and copies the
contents to a SQL Server table. As you can see below, the job cannot open
the file. I really have no idea why this is happening. Any assistance will
be greatly appreciated.


DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: Copy Data
from secinfo to [AdventFeeds].[dbo].[secinfo] Step DTSRun OnError: Copy
Data from secinfo to [AdventFeeds].[dbo].[secinfo] Step, Error = -2147217887
(80040E21) Error string: Error opening datafile: Access is denied.
Error source: Microsoft Data Transformation Services Flat File Rowset
Provider Help file: DTSFFile.hlp Help context: 0 Error
Detail Records: Error: 5 (5); Provider Error: 5 (5) Error string:
Error opening datafile: Access is denied. Error source: Microsoft
Data Transformation Services Flat File Rowset Provider Help file:
DTSFFile.hlp Help context: 0 DTSRun OnFinish: Copy Data from
secinfo to [AdventFeeds].[dbo].[secinfo] Step DTSRun: Package execution
complete. Process Exit Code 1. The step failed.

Check if the account under which SQL server Agent runs has the right to
access the file.

"John Criswell" <John Criswell (AT) discussions (DOT) microsoft.com> wrote

"John Criswell" <John Criswell (AT) discussions (DOT) microsoft.com> wrote

the default proxy domain account. To avoid this I run the package as a
scheduled task from Windows, using DTSRUN command line, with a specific user
naem for the job.
Jack Peacock