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 |
|
rubs_65
Posting Yak Master
144 Posts |
 Posted - 2004-09-30 : 17:25:40
|
| Hi,We have to test the performance of bcp when the output file will go to mapped network drive. But I am always getting error:Unable to open output file 'h:\backup\calls100K.txt'.I checked the permission on the directory and everyone have full permission on drive. I am able to ping and ftp to this folderi also tried using a URL to a shared folderIs it possible to bcp out to mapped drive and how can we do it?Thanks--Harvinder |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-30 : 17:47:07
|
| Where is the bcp command running from?Tara |
 |
|
|
rubs_65
Posting Yak Master
144 Posts |
Posted - 2004-09-30 : 17:56:31
|
| command prompt |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-30 : 17:58:26
|
| From the command prompt, can you do this:H: <enter>cd backup <enter>dir *.* <enter>?If so, please post the bcp command.Tara |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-09-30 : 17:59:00
|
| Use process explorer and see if there are any handles open on the file. If it's open, you won't be able to write to it. See if you can just create a new file.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
bcp to a mapped drive