Exporting a (.csv) file from SQL 2005
Hi,
I'm trying to export date to a (.csv) file from SQL 2005 and I keep getting a carriage return and line feed after each record. I have been told that this may be because it is getting exported in Unicode rather than ASCII. I do not have reporting services on my box. I have heard that there is a RSReportservice.config file, but I haven't been able to find it. Is there another way to change the configuration?
Thanks for your help in advance,
~ Tino
Software/Hardware used:
SQL Server Management Studio 2005
Software/Hardware used:
SQL Server Management Studio 2005
ASKED:
January 13, 2012 5:57 PM
UPDATED:
February 28, 2012 11:43 AM
Answer Wiki:
welcome to: http://www.plzzshop.com
The website wholesale for many kinds of fashion shoes, like the nike,jordan,prada,****, also including the jeans,shirts,bags,hat and the decorations. All the products are free shipping, and the the price is competitive, and also can accept the paypal payment.,after the payment, can ship within short time.
free shipping
competitive price
any size available
accept the paypal
http://www.plzzshop.com
jordan shoes $32
nike shox $32
Christan Audigier bikini $23
Ed Hardy Bikini $23
Smful short_t-shirt_woman $15
ed hardy short_tank_woman $16
Sandal $32
christian louboutin $80
Sunglass $15
COACH_Necklace $27
handbag $33
AF tank woman $17
puma slipper woman $30
http://www.plzzshop.com
To see all answers submitted to the Answer Wiki: View Answer History.
I use bcp and have no issues.
declare @bcp as varchar(2000)
set @bcp = ‘bcp “select * from server.dbo.table” queryout newserverfoldernametestfilename.csv -c -t, -T’
exec xp_cmdshell @bcp
On our server the bcp command requires the dbserver.dbo.tablename configuration. Doesn’t like just the tablename.
Thanks Smf,
I will try it again with your configuration.
~ Tino