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 |
|
b.veenings
Yak Posting Veteran
96 Posts |
 Posted - 2007-07-23 : 04:32:26
|
Hi all,I have an package that imports data from 8 different kind of databases, these are dbase IV databases.when i run the dts manually it's is not giving errors, but when i schedule the job it fails whith the following error:quote:
Executed as user: INFOTECHNOLOGY\clusteradminsql. ..._DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_8 DTSRun OnStart: DTSStep_DTSDataPumpTask_9 DTSRun OnError: DTSStep_DTSDataPumpTask_8, Error = -2147467259 (80004005) Error string: [Microsoft][ODBC dBase Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 1023 (3FF) Error string: Error source: Help file: Help context: 0 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSDataPumpTask_8 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnStart: DT... Process Exit Code 9. The step failed.
I configured the user clusteradminsql to the path where the databases are located but still it won't run.thnx.BenNeed an SQLDB consultant?check www.veeningsengineering.nl |
|
|
HSalim
Starting Member
1 Post |
Posted - 2007-07-23 : 05:02:52
|
| use unc paths to your tables rahter than mapped drives |
 |
|
|
b.veenings
Yak Posting Veteran
96 Posts |
Posted - 2007-07-23 : 05:28:13
|
| yep it worked:-)thnx for your help.Need an SQLDB consultant?check www.veeningsengineering.nl |
|
|
|
|
|
|
DTS package fails when it's running on its schedul