Outputting a CSV file

Question

Post reply

Outputting a CSV file

rightfield

SSCrazy

Points: 2418
More actions
December 17, 2008 at 11:10 am

#197608

Hi, what do I need to learn so I can output a CSV file from a stored procedure? I am using SQL Server 2005. Thank you for all comments. Warm regards,

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 1

SSIS, CmdShell/BCP, OPENROWSET, or Text based linked servers... each of which are in Books Online.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Ron McCullough SSC Guru Points: 63877 More actions · Answer 2

May I suggest that you may want to start learning how to use the Import Export Wizard in SQL Server Integration Service from Books On Line (BOL) using:

http://msdn.microsoft.com/en-us/library/ms365330(SQL.90).aspx

Then again using BOL look at the BCP (Bulk Copy Utility) here:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/73e949de-67a3-4c84-9735-7da1ad4ba34a.htm

The you can go on to use OPENROWSET - but you already have enough reading and can use BOL to learn about / how to for OPENROWSET

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]