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 |
|
Rach2009
Starting Member
37 Posts |
 Posted - 2009-11-13 : 06:54:05
|
| HiI am currently trying to save a format file via a bcp interactive session but when I get to the end and say 'Y' to saving the file and specifiy the filepath and name ("C:\Temp\Shipped.fmt"), it fails to save and I get an error message saying:-SQLState = HY000, NativeError=0, Error=[Microsoft][SQL Native Client]Unable to open host data-fileAny ideas why this is happening? Am I entering the filepath/name correctly?Thanks!Rachel |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Rach2009
Starting Member
37 Posts |
Posted - 2009-11-13 : 11:16:04
|
| Do you want to save this format information in the file [Y/N] YHost filename [bcp.fmt]: "\\uksql04\Insert$\Shipped.fmt" ...and then the error message appears as above. The Insert folder is a shared SQL folder.Do you need the details of the format file? This is quite lengthy but for the most part I just follow the prompts. The initial bcp command is the following:-bcp Dispatcher_Archive.dbo.ORDER_HEADER In "\\uksql04\Insert$\Shipped.csv" -S UKSQL04 -T -t","Many ThanksRachel |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Saving Fmt Files via bcp