Hello all,

I am trying to export the contents of a table in a database to a .csv file.
At this point I wish to export the entire table. Using the DTS wizard I was
able to find an option for a flat file. This was not sufficient for our
development group however as they require a .csv file. Can anyone here tell
me if this is possible and how to do this?

Thank you very much,
John

what i
"John Lloyd" <JohnLloyd (AT) discussions (DOT) microsoft.com> wrote

I must learn to finish sentences

a csv file can be thought of as nothing more than a comma seperated text
file.

When you use the destination adapter for a flat file you can tell it to add
the .csv extension and you can dictate the column terminator be a comma.

For what more could they ask?

Allan




"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Wow thank you very much - I have a thick skull sometimes. That completely
solved my problem

Have a great day!

John


"Allan Mitchell" wrote:

This is something I might be interested in. How do I accomplish this?
Is this being done within a dts package or from an external application?

Allan Mitchell wrote:

--
Message posted via http://www.sqlmonster.com

Try www.sqlscripter.com to export data to text/csv.
It's free.


"John Lloyd" wrote: