DTS Package Schedule

Hallo

I have a DTS Package which reads data from a Access Database and
imports it to SQL Server. This package runs without error when it is
executed trough Enterprise Manager.

When I create a job with "Schedule Package" and then try to run the
job, it gives errors like this:

Ausfhrt als Benutzer: SQL-S002MUR\SQL_Admin. ...db Das System kann
das angegebene Laufwerk nicht finden.DTSRun: Ldt... DTSRun: Fhrt
aus... DTSRun OnStart: DTSStep_DTSCreateProcessTask_1 DTSRun
OnError: DTSStep_DTSCreateProcessTask_1, Fehler = -2147220330
(80040496) Fehlerzeichenfolge: CreateProcessTask
'DTSTask_DTSCreateProcessTask_1': Prozess gab Code 1 zurck. Dieser
stimmt nicht mit dem
...

That means the system cannot find the specified drive.

SQL Server and SQL Server Agent are running as SQL_Admin, I am also
logged in as SQL_Admin when I run the package in Enterprise Manager.

Thank you very much, if someone can give me a hint.
HP"HP Fuchs" <rachid.fuchs@.bluemail.ch> wrote in message
news:f13bcfe2.0308220823.32366179@.posting.google.c om...
> Hallo
> I have a DTS Package which reads data from a Access Database and
> imports it to SQL Server. This package runs without error when it is
> executed trough Enterprise Manager.
> When I create a job with "Schedule Package" and then try to run the
> job, it gives errors like this:
> Ausfhrt als Benutzer: SQL-S002MUR\SQL_Admin. ...db Das System kann
> das angegebene Laufwerk nicht finden.DTSRun: Ldt... DTSRun: Fhrt
> aus... DTSRun OnStart: DTSStep_DTSCreateProcessTask_1 DTSRun
> OnError: DTSStep_DTSCreateProcessTask_1, Fehler = -2147220330
> (80040496) Fehlerzeichenfolge: CreateProcessTask
> 'DTSTask_DTSCreateProcessTask_1': Prozess gab Code 1 zurck. Dieser
> stimmt nicht mit dem
> ...
> That means the system cannot find the specified drive.
> SQL Server and SQL Server Agent are running as SQL_Admin, I am also
> logged in as SQL_Admin when I run the package in Enterprise Manager.
> Thank you very much, if someone can give me a hint.
> HP

This KB article covers this issue in detail:

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

Simon