Hi Eric,
This is a known issue with the DTS Flat File provider. The previous contents of the file will be
overwritten by the last executed data pump operation. You would have to use separate files to store
individual query results or use the File System Object to open a file for SEQUENTIAL ACCESS in the
Append mode.
HTH
Ashwin
This posting is provided "AS IS", with no warranties, and confers no rights.
P.S.: Please post the SQL Server version, OS version, Exact error message in future posts so that I
can provide you with accurate information specific to your version of the product.
--------------------
Quote:
>>> Content-Class: urn:content-classes:message
>>> Subject: Appending files in DTS
>>> Date: Mon, 3 Dec 2001 14:09:22 -0800
>>> Lines: 8
>>> MIME-Version: 1.0
>>> Content-Type: text/plain;
>>> charset="iso-8859-1"
>>> Content-Transfer-Encoding: 7bit
>>> X-Newsreader: Microsoft CDO for Windows 2000
>>> X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
>>> Thread-Index: AcF8RynRv0S334HRRPSVa88Bo9lcQw==
>>> Newsgroups: microsoft.public.sqlserver.dts
>>> Path: cpmsftngxa07
>>> Xref: cpmsftngxa07 microsoft.public.sqlserver.dts:10303
>>> NNTP-Posting-Host: TKMSFTNGXA04 10.201.232.163
>>> X-Tomcat-NG: microsoft.public.sqlserver.dts
>>> I am trying to write to a file from a Query, using the
>>> Text file Destination Task in DTS. However there is more
>>> than one query that I want to output for the text file.
>>> When I execute the package, it writes the output of the
>>> first query to the textfile, and then the second query
>>> will overwrite the output of the first query. Thus I only
>>> have the output from the second query. Does anyone know
>>> how to get around this?
Appending files in DTS