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 - 2005-09-13 : 07:24:59
|
| Joe writes "Hello,I have created a DTS package that simply exports data from SQL Server into an Access .MDB. The package itself runs fine but it does not run when scheduled. The path of the access .MDB is \\ServerName\Share\ClientName\ProjectNumber - ProjectName\somefile.mdb. How can I get around the - in the directory name without renaming the directory or creating a mapped drive? I am running SQL Server 2000 sp3 on Windows 2003 Server.Thanks!" |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-09-13 : 09:45:14
|
| a) Is this share visible from the serverb) Does the server have access to the share?...It runs , when scheduled in the context of the server?Only other thing I can think of is to enclose the directory name in [] or '' |
 |
|
|
|
|
|
DTS Invalid Directory Error