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 |
|
jpaul
Starting Member
2 Posts |
 Posted - 2004-12-11 : 02:17:55
|
| I'm looking for some assistance with importing data from a file on one compuer to a SQL database on a remote computer.I have the local file path (D:\...) as part of the bulk insert command but keep getting an error that the file path is not valid. I tried to share the local folder on the remote system but it does not work.Any ideas?Thanks in advance.jpaul |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2004-12-11 : 03:07:50
|
| There are a few things that it could be:1) Are you using BCP to import the data? The code is executing on the SQL Server so it assumes that file paths are local to the SQL Server. Move the file to the SQL server.2) The SQL account does not have access rights to the path you defined. Talk to your DBA/IT Dept to change the rights.HTH=================================================================Happy Holidays! |
 |
|
|
jpaul
Starting Member
2 Posts |
Posted - 2004-12-11 : 11:25:01
|
| Does SQL Server support mapped drives? e.g. if the remote folders containing the text files to be imported into the database are shared using Windows sharing (Z:\FolderName) or (\\ComputerName\Folder)? |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-12-11 : 11:46:19
|
| It is better to use UNC paths instead of mapped drives, since drive mappings may not exist or could be changed. |
|
|
|
|
|
|
Importing Data into a remote SQL server