DTS Package Scheduling Problem

• TRUSTED4All

  Newbie

  Points: 5

  More actions

  April 1, 2003 at 2:28 am

  #105481

  Hello Everybody :

  Package Name = Attendance

  Owner = Dtc\Administrator

  Job Created after I sceduled the package = Attendance_Job

  Owner = Sa

  SqlServerAgent is running by login = LocalSystem Account

  Now the problem that is killing me is scheduling. When I run the package manually, it runs and when I schedule it, it says successfull but the fact is the package does not get executed. I am using Sql Server 7. Is it becoz of the job owner as SA ? SA is a member of sysadmin role and it is SQL Server account. Can anybody please help me to solve this problem ? Its VERY URGENT...

  Thnx

  - Marjo.

• jfb

  SSCrazy

  Points: 2469

  More actions

  April 2, 2003 at 12:46 pm

  #452890

  Hi,

  Next time please not put urgent, because maybe is urgent for you but not for anybody else.

  Read this article, maybe you answer is there.

  http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q269074

  Johnny