"John Criswell" <John Criswell@discussions.microsoft.com> wrote in message
news:B1585817-EA6A-4117-8717-F2935299C42F@microsoft.com...
>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.
>

"John Criswell" <John Criswell@discussions.microsoft.com> wrote in message
news:B1585817-EA6A-4117-8717-F2935299C42F@microsoft.com...
> 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.