Merging Files With DTS

#1

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.

--
Posted via http://dbforums.com

#2

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

"robmarchi" <member18891 (AT) dbforums (DOT) com> wrote

Quote:

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.

--
Posted via http://dbforums.com

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

Merging Files With DTS

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

Merging Files With DTS - 08-12-2003 , 07:53 AM

Re: Merging Files With DTS - 08-12-2003 , 09:08 AM