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 |
|
robvolk
Most Valuable Yak
15732 Posts |
 Posted - 2001-06-05 : 10:22:58
|
| I'm becoming convinced that DTS, which I really love, stands for Dumb-Ass Tub of S#it.Here's what happened: last week I converted my NT 4.0 roaming profile to a local profile. This one DTS job that used to run fine no longer runs under SQL Agent. Works perfectly when run manually, and all my other DTS jobs were unaffected.The DTS package hits an MS Access database on a Novell network drive. SQLAgentCmdExec is only a local user, not a Novell user. Has anyone else had a similar problem and found a solution? Is there a way to map one NT user to another? And just out of curiosity, why did this work when I had a roaming profile? (I really can't go back to a roaming profile, it caused a lot of non-SQL problems)Thanks!P.S. - Anyone got a line on the Jet OLE DB settings that appear on the Advanced tab? Like, what are the legitimate values and such?Edited by - robvolk on 06/05/2001 11:43:22 |
|
|
|
|
|
DTS Job Fails