Export data into CSV file in unix format

Question

Post reply

Export data into CSV file in unix format

HBK_4700

SSCrazy Eights

Points: 8932
More actions
June 22, 2010 at 2:17 pm

#140951

Sofar We are providing the db data to client in excel files using import/export wizard in sql server 2005.
Now client is asking the tables data in saperate CSV files in unix format. is it possible?
As far as I know SQL Server 2005 runs on Windows system. Please advice
Forum Etiquette: How to post Reporting Services problems

[/url]

Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]

How to Post Performance Problems - by Gail Shaw
[/url]

mister.magoo SSC-Forever Points: 47174 More actions · Answer 1

Hi,

You can use the same export data tool, but choose Flat File Destination and make sure to select LF as the row delimiter.

If it has worked, when you open one of the text files in Notepad, it will all be one long line, whereas in Wordpad it will be one line per row of data.

Make sure you transfer the files in Binary mode if using FTP or zip them up before sending so that they are not modified to include a CR-LF line ending.

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

HBK_4700 SSCrazy Eights Points: 8932 More actions · Answer 2

Thank you,

But how to convert the CSV windows file into CSV (Unix format). Is there any feature in SQL Server, or any third party tools? Please let me know.

In our database there are 250+ tables.

mister.magoo SSC-Forever Points: 47174 More actions · Answer 3

laddu4700 (6/23/2010)
Thank you,
But how to convert the CSV windows file into CSV (Unix format). Is there any feature in SQL Server, or any third party tools? Please let me know.
In our database there are 250+ tables.

Changing the row delimiter to only LF makes it compatible with Unix.

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

HBK_4700 SSCrazy Eights Points: 8932 More actions · Answer 4

HBK_4700

SSCrazy Eights

Points: 8932

June 23, 2010 at 8:59 am

#1184006

Thanks Magoo,

HBK_4700 SSCrazy Eights Points: 8932 More actions · Answer 5

mister.magoo (6/23/2010)
laddu4700 (6/23/2010)
Thank you,
But how to convert the CSV windows file into CSV (Unix format). Is there any feature in SQL Server, or any third party tools? Please let me know.
In our database there are 250+ tables.
Changing the row delimiter to only LF makes it compatible with Unix.

If Understood correct,

I need to select the file.csv

format : delimited

select: column names in the first data row

row delimited: LF

Column delimiter: Comma {,}

So output CSV file is compatible with Unix, Please correct me If I am wrong.