sql server dts: how do you bulk copy into text file? -- sql server dts

how do you bulk copy into text file?

br
4/14/2006 11:10:02 AM

sql server dts: 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)?

Re: how do you bulk copy into text file?

br
4/14/2006 11:41:02 AM

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.

[quoted text, click to view]

Re: how do you bulk copy into text file?

Allan Mitchell
4/14/2006 2:20:24 PM

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

[quoted text, click to view]

Re: how do you bulk copy into text file?

Tomer Shoval
4/16/2006 1:50:14 AM

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

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.