I have create a DTS package and have tested it by running it manually from the enterprise manager console and it works ok.
The problem I am having is that when I schedule this job to run it failes reporting the following error message.
The job failed. Unable to determine if the owner (Domain\<username>) of job Import <JobName> has server access (reason: Could not obtain information about Windows NT group/user 'Domain\<username'. [SQLSTATE 42000] (Error 8198)).
I have tried changing the owner of the job to various other users including the systeme administrator but still no luck.
Any ideas ???