Is there any way DTS can read a trailer or header in a
text file. Let say this is the flat file:

101 20056 NV01 103635 Decatur & Craig
102 30123 NV01 103636 Drake Plaza
103 26522 NV01 103636 Drake Plaza
104 56222 CA01 105326 West & Decatur
## 20030912 506040

The last line ## has the date and the character count for
the file. How can I have my DTS package read this last
line and dump the information in someplace else.

Thanks is advance for any help. Sandra

The answer is to use an ActiveX object in DTS and use the
Scripting.FileSystemObject, this will allow you to read an input file line
by line and you can choose where to write the data depending on the data.

This can be slow for large files.

Pete

"Sandra" <silvah (AT) wellsfargo (DOT) com> wrote

In article <uxv0MJEfDHA.2236 (AT) TK2MSFTNGP12 (DOT) phx.gbl>, Peter Hall
<pete_ha11 (AT) hotmail (DOT) com> writes
together, e.g.

copy header.txt+data.txt+footer.txt file.txt


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org