sql server dts: Merging Files With DTS -- sql server dts

Merging Files With DTS

robmarchi
8/12/2003 12:53:53 PM

sql server dts:
I need to Merge some txt files, and I want to use DTS. It´s Possible?
When I´ve tried it, I don´t Known where I set de Destination to be an
"append" file.
If i have some transformation, it´s always dlete de old file and create
a new file with the lines of the transformation. Somone Known if merging
files in DTS it´s possible?

Thank´s.

--

Re: Merging Files With DTS

Allan Mitchell
8/12/2003 3:08:08 PM

If you want to merge two files you can use

COPY TextFile1.txt + TextFile2.txt TextFile3.txt

This will merge TextFile1 and TextFile2 into a new file called TextFile3

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

[quoted text, click to view]