Repost of DTS fails to run as scheduled job

[SteveR77]

Tom Sark's post from October was a life saver and I thought it would be helpful to repost it for others who might be in the same boat as me.


This was the ONLY place that I could find information that I could use to resolve the problem. So thanks once again to Tom, and for those of you who need the information. Here it is:



Here's a checklist for you that you can follow:

** The package is owned by you
** The agent account is a domain account being authenticated by a
DC in, say, DOMAIN2
** The SQLAgent is being run under the context of a domain account
** The SQLAgent account and your account are both members of
BUILTIN\administrators on the SQL Server
** The SQLAgent account and your domain account are members of the sysadmin fixed server role
** The directory in which the files reside is shared, with
"Change" and "Read" permissions granted to BUILTIN\administrators
** The SQLAgent account and your domain account have been permitted access to the SQL Server database
** These users have not been explicitly DENIED access to any object being "touched" by the DTS package in the database.

 

[TomSark]

I'm glad I could help...

Name a kid after me or something... LOL

Tom

 

[SteveR77]

Tom,

All done with the kids so I can't name one after you. If I can get my system admin on the horn and get this to work it be sure to let him know that you were the man with our solution though.

Have a good one & thanks.

It's great when the forums work so well. s-)

 

[foxdev]

Tom, I think a FAQ is in order.

Robert Bradley

http://www.foxdev.com/

 

[TomSark]

Okie Dokie..

Tom