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 - 2001-09-28 : 09:11:53
|
| BalMu writes "Here is My questions. I am trying to copy the bulk of data from the Sql server to the text file using the BCP command provided by the sql server. The table is containing 15,000 records, When I execute the BCP, It is copying only just first 1000 records, afterwards, it is saying 0 records have been copied. So, Finally the text file is containing just 1000 records and the bcp leaves remaining 14,000, I don't know why. I tried with the different database server's. It did not work. Can you give me the Idea what I need to do to take all of the records from the database?.Here is the command which i have used.bcp test..customer out -ocustomer.txt -Scus -Ucus -Pcus -c (to take in character format)Result.Starting copy1000 rows copied.0rows copied.timed out ....Thanksbala.V" |
|
|
|
|
|
Question regarding the Bulk copy programming