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 |
|
scottpt
Posting Yak Master
186 Posts |
 Posted - 2004-12-22 : 12:41:25
|
| Running a import from excel 2000 to SQL 2000 Ent sp3a + hotfix.When this is run by a non SA user, using an windows account that is not part of the administrators group, it fails with this error. I can log in as the same nonSA user into enterprise manager and run the package with failure, it is only when I run it as a a job.--------------------------------------------- DTSRun: Loading...DTSRun: Executing...DTSRun OnStart: Delete from Table [TESTDB].[dbo].[Importtable] StepDTSRun OnFinish: Delete from Table [TESTDB].[dbo].[Importtable] StepDTSRun OnStart: Copy Data from 'Class Participation Review (Reg$' to [TESTDB].[dbo].[Importtable] StepDTSRun OnError: Copy Data from 'Class Participation Review (Reg$' to [TESTDB].[dbo].[Importtable] Step, Error = -2147467259 (80004005) Error string: Unspecified error Error source: Microsoft JET Database Engine Help file: Help context: 5000000Error Detail Records:Error: -2147467259 (80004005); Provider Error: 0 (0) Error string: Unspecified error Error source: Microsoft JET Database Engine Help file: Help context: 5000000DTSRun OnFinish: Copy Data from 'Class Participation Review (Reg$' to [TESTDB].[dbo].[Importtable] StepDTSRun: Package execution complete.NULL(22 row(s) affected) |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-12-22 : 15:06:08
|
| Are you saying it only succeeds as a job? If so, tell us what the DTS package is doing.Tara |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-12-22 : 23:57:45
|
| dts run as a job will run under the context of the sql server, be sure that the nonSA account has enough permissions to perform the transactions involved. like delete and insert permissions perhaps, if you're creating object, db_ddladminotherwise, assign the sa to be owner of the job--------------------keeping it simple... |
|
|
|
|
|
|
DTS and windows permissions