I have a tab deliminted task that imports data into a SQL Table that runs
succesfully if executed. But when I shedule this task if fails. The text
file is on a server in a remote location. I have mapped a local drive to
this path and when I run the scheduled job it gives me the following
information.

DTSRun: Loading... DTSRun: Executing... DTSRun OnStart:
DTSStep_DTSDataPumpTask_1 DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error
= -2147217887 (80040E21) Error string: Error opening datafile: The
system cannot find the path specified. Error source: Microsoft Data
Transformation Services Flat File Rowset Provider Help file:
DTSFFile.hlp Help context: 0 Error Detail Records: Error: 3
(3); Provider Error: 3 (3) Error string: Error opening datafile: The
system cannot find the path specified. 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.

Any ideas why it runs manually and not through a schedule?

TIA

The scheduled package runs under SQL Server Agent account. Usually it is
"local system", who has no right to access remote folders.
Make sure SQL server Agent service runs under a proper account (? a domain
administrator, for example ).

Francesco Anti

"Lontae Jones" <LontaeJones (AT) discussions (DOT) microsoft.com> wrote

Its a Domain account but cant find the path but if I execute the package
myself it runs successfully. Same error.

"Francesco Anti" wrote:

Probably SQL server agent can't retrieve the mapping you have done...try to
refer to the remote folder using \\remoteserver\folder

Francesco Anti

"Lontae Jones" <LontaeJones (AT) discussions (DOT) microsoft.com> wrote

I tried an UNC path but it couldnt find the path.

I am getting the same error. Any Ideas?

DTSRun: Loading... DTSRun: Executing... DTSRun OnStart:
DTSStep_DTSDataPumpTask_1 DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error
= -2147217887 (80040E21) Error string: Error opening datafile: The
system cannot find the path specified. Error source: Microsoft Data
Transformation Services Flat File Rowset Provider Help file:
DTSFFile.hlp Help context: 0 Error Detail Records: Error: 3
(3); Provider Error: 3 (3) Error string: Error opening datafile: The
system cannot find the path specified. 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.

"Francesco Anti" wrote:

If the account under which the job runs is the local system account then it cannot see off its own HDD no matter how hard you try

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

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"Lontae Jones" <LontaeJones (AT) discussions (DOT) microsoft.com> wrote