RE: Export to text/CSV Append Data

#1

tat's a easier method i guess.

Thanks Allan and SQL.

"Allan Mitchell" wrote:

Quote:

You can also export each piece of data to its own file and then use a
batch file and the DOS COPY command to meld them together.

--

----------------------------------------
Allan Mitchell (Microsoft SQL Server MVP)
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

"SQL" <SQL (AT) discussions (DOT) microsoft.com> wrote in message
news:C87B7466-6E52-47AD-8020-148E3AE979B9 (AT) microsoft (DOT) com:

Put the data into a 'temp' file
Use File System Object to append the data to the correct file

http://sqlservercode.blogspot.com/

"k_s" wrote:

Hi All,
Is it possible to Append SQL data to a text or CSV fiel. In geeral case the
data is replaced with new data and old data is lost.
I am using Data pumping task for this.

thanks

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

RE: Export to text/CSV Append Data

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

RE: Export to text/CSV Append Data - 10-02-2005 , 11:33 PM