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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-03-04 : 08:21:31
|
| Krishna Kumar writes "I created a DTS Packege through the enterprise manager from My client machine to transfer data from a SQL200 DB to an Access DB on my machine using a T-SQL. When I run the packege manually It ran fine. But when I scheduled for a certain interval I am getting an eroor. The error is DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005) Error string: Could not find file 'C:\Test.mdb'. Error source: Microsoft JET Database Engine Help file: Help context: 5003024 Error Detail Records: Error: -2147467259 (80004005); Provider Error: -534578963 (E022F8ED) Error string: Could not find file 'C:\Test.mdb'. Error source: Microsoft JET Database Engine Help file: Help context: 5003024 DTSRun OnFinish: DTSStep_DTSDataPumpTask_1 DTSRun: Package execution complete. Process Exit Code 1. The step failed." |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-03-04 : 12:28:17
|
| When you schedule a package, it uses the server's information. So the path and file name must exist on the database server. It also uses the account that the MSSQLSERVER service logs on with. That account must have all of the needed permissions in order for it work without errors. So investigate the path and filename from the server's perspective (not your client machine) and also the account that the MSSQLSERVER service uses.Tara |
 |
|
|
|
|
|
Scheduling a DTP to transfer data from SQL2000 to an AccessDB