Hi,
I need to load a bunch of text files

Q) Is there a way to open multiple text files in DTS for loading ?
Q) Is there a way to open text files in DTS with a wild card e.g. *.txt ?
Q) Is there a way to concatenate the files ? and then I can load the
concatnated file.



Thank you

--
Luq K

Q1 == No not in this version
Q2 == No not in this version
Q3 == Have you seen the DOS COPY cmd?



--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Luq K" <LuqK (AT) discussions (DOT) microsoft.com> wrote

You can create a DTS that will run a file and loop back to the beginning to
process the next file. I have done this before and it works great. Let me
know if you need any help.

Rick

"Luq K" <LuqK (AT) discussions (DOT) microsoft.com> wrote