Dear all,

I want to transfer a text file content to a SQL2000 table using DTS.

When I use DTS and choose "run immediately", it works fine.

When I set schedule to call in SQL2000 Job, and try to test the schedule by
manual start, it shows the following error:

The text file is fron Network drive, and the connect user have all rights to
that file.

Help~~~~~

Ivan


Executed as user: SQL_TEST\SYSTEM.
DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: Copy Data from ATTN to [TESTDB].[dbo].[ATTNTEST] Step
DTSRun OnError: Copy Data from ATTN to [TESTDB].[dbo].[ATTNTEST] Step,
Error = -2147467259 (80004005)
Error string: Error opening datafile: Access 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 Denied.
Error source: Microsoft Data Transformation Services Flat File Rowset
Provider
Help file: DTSFFile.hlp
Help context: 0
DTSRun OnFinish: Copy Data from ATTN to [TESTDB].[dbo].[ATTNTEST] Step
DTSRun: Package execution complete.
Process Exit Code 1. The step failed.

Hello Ivan,

have a read of this

http://support.microsoft.com/?kbid=269074

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com