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 |
|
muhiar
Starting Member
37 Posts |
 Posted - 2006-03-26 : 02:15:55
|
| hi alli have a problemin the cmd i write the following c:>> bcp "pubs..authors" out c:\test\xx.txt -C -f c:\test\xx_fmt.txtthe problem is that it gets stuck with start copying and keeps like that i checked for the xx.txt it is created by the commandwhy this happen?????????? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-03-26 : 02:21:17
|
"the problem is that it gets stuck with start copying and keeps like that i checked for the xx.txt it is created by the command"Can you explain more on the this ? What do you mean by stuck ? Is there any error message ?
KHChoice is an illusion, created between those with power, and those without.Concordantly, while your first question may be the most pertinent, you may or may not realize it is also the most irrelevant |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-03-26 : 10:59:57
|
| Have a look athttp://www.nigelrivett.net/SQLTsql/BCP_quoted_CSV_Format_file.htmlStart with something simple - just bcp the table without a format file then build from there.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
bcp problem