I am looking through Books Online, and I cannot find a clear example on how
to Bulk Copy from SQL Server into a text file (for archiving old data).

The only line I could find states: "Bulk copying supports the following bulk
copy transfers: ...., From a SQL Server table or view into a data file, such
as a text file or tab-delimited file."

I tried to do this in a DTS package, but all I could see was the Bulk Insert
task, and that appears to only lets me copy from a text file into a SQL
table. What can I look to accomplish the opposite (From SQL Table into Text
file)?

You can;

1. Use the Datapump task
2. Use bcp in an ExecuteProcess Task
3. Use this

Bulk Export Task
(http://www.sqldts.com/default.aspx?237)


HTH

--


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com


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

Thanks very much for your insight. I can see the ExecuteProcess Task and
found the bcp.exe file in the Binn folder. I will try to create my solution
through this, and ask my DBA about the other options (the Bulk Export task
looks like a sleek solution).

Have a great day.

"Allan Mitchell" wrote:

NP.
just keep in mind that i've found that the bulk export task has issues
with collations other then the deafult English one.