I need to be able to take an existing table's data, and automatically export
it to a tab delimited text flat file. Suggestions / tutorials on how this
can be done? I then need to be able to call this from ASP...

[quoted text, click to view]

Always tell us what version you are using. DTS (2000) or Integration
Services (2005) is one option. Another is BCP. Another alternative
(especially in 2005) is to output an XML query instead of a delimited file.
Lookup some of these things in Books Online.

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

Sorry David.. total newbie here... running 2005 .. Books Online? What's BCP?

[quoted text, click to view]

BCP is a Bulk Copy utility that can be used to import and export data.

Books Online is the documentation that comes with SQL Server. You can lookup
any of these terms in Books Online. If you don't have it my signature has
the link. You can also download it:
http://www.microsoft.com/sql/downloads/2005/default.mspx

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--