We help IT Professionals succeed at work.

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

loiswalk
loiswalk asked
on
Medium Priority
383 Views
Last Modified: 2012-06-22
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.
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2012
Commented:
In a word: Permissions.  The SQL Server Agent service startup account does not have the correct permissions to run the job.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
Thanks.  That did it.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.