Export all tables and views to files

#1

Hello,

Can some one help me to export all the tables and views, with the name of
the columns, to txt file with the name of the table or view.

NOTE I use bcp but it does not copy the columns names.

#2

Hello again,

I try to use Bulk Export Task but I can not find the graphical interface to
do it. Some one know where is it?

Regards,
Andrew

"Andrew Retzlaff" <sorry (AT) my_email_is_private (DOT) com> wrote

Quote:

Hello,

Can some one help me to export all the tables and views, with the name of
the columns, to txt file with the name of the table or view.

NOTE I use bcp but it does not copy the columns names.

#3

Darren's BULK Export task comes with a GUI. Did you follow the instructions
on the site?

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Andrew Retzlaff" <sorry (AT) my_email_is_private (DOT) com> wrote

Quote:

Hello again,

I try to use Bulk Export Task but I can not find the graphical interface
to
do it. Some one know where is it?

Regards,
Andrew

"Andrew Retzlaff" <sorry (AT) my_email_is_private (DOT) com> wrote in message
news:%23sZUaCByDHA.1688 (AT) TK2MSFTNGP10 (DOT) phx.gbl...
Hello,

Can some one help me to export all the tables and views, with the name
of
the columns, to txt file with the name of the table or view.

NOTE I use bcp but it does not copy the columns names.

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

Export all tables and views to files

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

Export all tables and views to files - 12-21-2003 , 04:22 PM

Re: Export all tables and views to files - 12-21-2003 , 05:39 PM

Re: Export all tables and views to files - 12-22-2003 , 01:28 AM