Re: Another DTS Scheduling question

Hello skyetech,

Owner of the package matters little. It is the owner of the job that counts. It is this guy's credentials that get used. Can you log on to the TS session as the account that will run the job

Job Owner == Sysadmin then the service account else the proxy account

See if you can run the package interactively now.



--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

I looked at the properties of both the scheduled job and the package.
The owner of the scheduled job is the same as the creator of the dts
package and the computer name for the package is the sql server, not
any workstation.



.

Relevant Pages

  • Re: Changing packages owner
    ... > account) created a package, the owner of the package appeared as User_A. ... I changed owner in the ...
    (microsoft.public.sqlserver.security)
  • Re: Error saving DTS Package
    ... There should not be a problem with the package owner - we ... I tried taking all the SQL Server resources offline and ... and trying saving the package again - same ...
    (microsoft.public.sqlserver.dts)
  • Changing packages owner
    ... account) created a package, the owner of the package appeared as User_A. ... the new account of the same user is User_B. ... I changed owner in the ...
    (microsoft.public.sqlserver.security)
  • RE: How to change a local DTS packages owner or how to open a passwor
    ... Local packages are held in the msdb database table sysdtspackages. ... simple "SELECT * FROM sysdtspackages" you can see the owner for each package. ... updates the owner text field, but it also updates the owner_sid field. ...
    (microsoft.public.sqlserver.server)
  • Re: Changing DTS Job owners
    ... The owner of a package makes very little difference to anything but obviously the owner of the job is something different. ... you delete the SID that goes along ... columns of that particular package (in sysdtspackages) to someone else, ...
    (microsoft.public.sqlserver.dts)