Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vux
Starting Member
45 Posts |
 Posted - 2004-09-15 : 23:49:40
|
| Hello,I have a strange problem:When I run the DTS directly it works fine. But when I schedule the exceution of the DTS package as daily task it fails.The error message gives no hints to what the problem is.Does any of you made similar experience?Thx! |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-09-16 : 00:04:30
|
| Normally, these are permissions issues. Does the job owner have permissions to run the DTS package? If there are any file shares accessed, does the job owner have permissions to the share.Many times, you have sa or the account running SQL Server run the DTS package and be the owner of the job. This would correlate to the domain user running SQL Server. That user would need access right to everything the DTS package requires.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
vux
Starting Member
45 Posts |
Posted - 2004-09-16 : 00:40:04
|
| HI you are right! but I already saw that problem, so I let the administrator make the job (i still own the Package, maybe we should chnage that too) then at least the permission problem was solved so now its sth else...thx |
|
|
|
vux
Starting Member
45 Posts |
Posted - 2004-09-16 : 02:20:07
|
| oh man, after changing also the DTS package owner to the admin account it works.the other thread here about this issue explained it!the owner of the package must have access to all tables and stuffed used in the package...http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=39929 |
|
|
|
|
|
|
DTS Package works direct but not as Job?!