DTS Package won't sucessfully execute when scheduled - HELP!!!
Posted on 2006-03-23
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.