Exporting data without wizzards?

#1

Is there I way to export data into .csv executing code not using wizzards?

Something similar to INFORMIX command.

UNLOAD TO //path/filename.csv DELIMITER ","
SELECT (WHATEVER) FROM TABLE

#2

BCP ?
DTS ? (although you may count the Gui as a Wizard)
SQL-DMO

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know

"aurelio" <aurelio (AT) discussions (DOT) microsoft.com> wrote

Quote:

Is there I way to export data into .csv executing code not using wizzards?

Something similar to INFORMIX command.

UNLOAD TO //path/filename.csv DELIMITER ","
SELECT (WHATEVER) FROM TABLE

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Exporting data without wizzards?

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Exporting data without wizzards? - 11-05-2004 , 01:57 PM

Re: Exporting data without wizzards? - 11-06-2004 , 02:16 AM