Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 328
  • Last Modified:

DTS Package won't sucessfully execute when scheduled - HELP!!!

I am using SQL Server 2000 and I have a DTS package that executes flawlessly when I execute it manually (you know, right click on the DTS package then click 'Execute Package').  However, when I schedule it to run at night (using SQL Server Agent) it fails with the following details:

Executed as user: PORTAL\SYSTEM. DTSRun:  Loading...   DTSRun:  Executing...   DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_1   DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_1   DTSRun OnStart:  DTSStep_DTSDataPumpTask_2   DTSRun OnError:  DTSStep_DTSDataPumpTask_2, Error = -2147467259 (80004005)      Error string:  [Navision Software a/s][Navision Financials ODBC Driver]Table does not exists       Error source:  Microsoft OLE DB Provider for ODBC Drivers      Help file:        Help context:  0      Error Detail Records:      Error:  -2147467259 (80004005); Provider Error:  15 (F)      Error string:  [Navision Software a/s][Navision Financials ODBC Driver]Table does not exists       Error source:  Microsoft OLE DB Provider for ODBC Drivers      Help file:        Help context:  0      DTSRun OnFinish:  DTSStep_DTSDataPumpTask_2   DTSRun:  Package execution complete.  Process Exit Code 1.  The step failed.

Yes, it's a Microsoft product called 'Navision' that uses a proprietary database.  I'm trying to import certain tables into SQL Server so I can query them in something I'm familiar with.  Any ideas?  Thanks.
0
loiswalk
Asked:
loiswalk
1 Solution
 
Anthony PerkinsCommented:
In a word: Permissions.  The SQL Server Agent service startup account does not have the correct permissions to run the job.
0
 
loiswalkAuthor Commented:
Thanks.  That did it.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now