Any ideas on the following error message, DTS package
owner is myself and I am a local Admin. Job ruuning is
under my domain account.

DTSRun: Loading... DTSRun: Executing... DTSRun
OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnError:
DTSStep_DTSDataPumpTask_1, 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: DTSStep_DTSDataPumpTask_1 DTSRun: Package
execution complete. Process Exit Code 1. The step failed.

Are you a member of the sysadmin role on the SQL Server?
If you are then it is executing under the SQL Server Agent service account
If not then it is executing under the proxy account. Do they have
permissions onto the file ?
Is the file local ? Are you using mapped drives? If yes then what about
using UNC?



--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Tracy Yang" <tracylyang (AT) hotmail (DOT) com> wrote

Yes, I am a local admin on OS and sysadmin role on SQL
server, the file is local and full control to Everyone.

OK so the job will be executing under the account that SQL Server Agent
starts under. Can you log in as that person to the box itself and run the
package ?

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Tracy Yang" <tracylyang (AT) hotmail (DOT) com> wrote