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 |
|
jamie
Aged Yak Warrior
542 Posts |
 Posted - 2005-10-31 : 08:27:21
|
| Hi, i have written a DTS package that copys data from tables in an access database to a sql database.when I execute the DTS package all is successful.however, when running as a job , it fails with the following error : [Microsoft][ODBC Microsoft Access 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.I am using a domain admin account to run the SQLSERVERAGENT service and that domain account has permissions to the access databases..why else would this fail ?regards,Jamie |
|
|
jamie
Aged Yak Warrior
542 Posts |
Posted - 2005-10-31 : 10:05:49
|
| just to let you know this worked fine on a win2000 server running sql2000now I am using win2003 server with SQL2000. |
 |
|
|
juvethski
Starting Member
46 Posts |
Posted - 2005-11-01 : 14:54:16
|
| check the accounts on the following (they all should be the same, to be on the safe side)- mssqlserver- sqlserveragent- sql server propertiesif they are all ok, it might be something to do with unc.~~~~~~~~~~~~~~~~how's your data? |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-11-02 : 01:40:24
|
| Refer this alsowww.sqldts.comMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
copying data from MS ACCESS to SQL2000 server