Appending files in DTS 
Author Message
 Appending files in 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?


Sat, 22 May 2004 06:09:22 GMT
 Appending files in DTS

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?



Mon, 31 May 2004 01:31:57 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Failed to Append a Text file into another Text file by Using DTS in SQL2000

2. How to append to a text file when exporting using DTS

3. How can you append or add own error message to DTS exception file

4. DTS append to existing file?

5. Append To Text File via DTS

6. DTS appending to a text file export

7. DTS to Text File Append?

8. Append to text files in DTS Designer?

9. Appending DTS output to Destination Files

10. Append to a text file using DTS

11. Append to a text file using DTS

12. Importing a Text File via DTS and adding the File Name as a column via DTS


 
Powered by phpBB® Forum Software