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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Problem Exporting to CSV

Author  Topic 

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2010-08-26 : 17:01:37
Hello everyone

I am trying to export a query result to a comma delimited CSV. But the problem is i have extra commas within the data. So when exporting to CSV my data is all over the place.

Is there a way i can get round this?

Kind Regards

Rob

MCTS / MCITP certified

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-08-26 : 17:05:06
You will need to use a different delimiter or double quote your data.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2010-08-26 : 17:11:16
Could you give me an example for double quoting please?

MCTS / MCITP certified
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-08-26 : 18:06:16
SSIS/DTS allows you to do it. It's one of the options when you export data.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2010-08-31 : 09:27:25
could someone tell me what function within SSIS i would use to do this.

Regards

Rob

MCTS / MCITP certified
Go to Top of Page
   

- Advertisement -