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 |
|
xicom_sachin
Starting Member
1 Post |
 Posted - 2006-10-28 : 08:40:13
|
| Hi,I have to export millions of record to csv file so i use bcp commant to export data to csv file, it work fine at local server but online it works for 100 records but when i try to export more like 100000 it doesn't work. Please help to sort out this problem.I am using this command: exec master..xp_cmdshell 'bcp "SELECT top 100000 phoneNumber,state FROM lms.dbo.customer" queryout "D://lms/downloadfile/never.csv" -c -q -t, -U"username" -P"password"' |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2006-10-28 : 11:06:23
|
does the path D://lms/downloadfile exist on the remote server? also, what's the error exactly? you can trap detail about the error using the -e flag.
SqlSpec - a fast, cheap, and comprehensive data dictionary generator forSQL Server 2000/2005 and Analysis Server 2005 - http://www.elsasoft.org |
 |
|
|
|
|
|
bcp + no of rows export to csv