I have seen the import examples from sqldts
(http://www.sqldts.com/default.aspx?246) but was wondering
if there is anyway to automate the importing of multiple
text files with each text file going into a separate SQL
table. The format of the text files are all the same.

You would ideally need to build a datapump for each table.
I would seperate the files into folders according to destination.
Each DataPump would then source from only one folder.

Once you have this setup then it is plain sailing from there.

The problem with the

1 Datapump - Sourcing many formats of file into many different tables

is that you would need to rebuild the datapump mappings every time and that
is costly.

--
--

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


"csl" <cslatta (AT) carolina (DOT) rr.com> wrote

In message <1704901c420db$a424ac50$a001280a (AT) phx (DOT) gbl>, csl
<cslatta (AT) carolina (DOT) rr.com> writes
If the text files are all the same format then I don't see why the
article you mentioned could not be used for this. You currently change
the source filename, so at the same time you could change the
destination object name.

I think Allan must have missed the comment about being the same format.

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

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

No he read it as 20 source definitions and 20 seperate destinations. I read
it as all the 20 destinations are of differing structures. I therefore may
have misread the fact that all these tables have the exact same structure in
the same DB if that is the case because I thought that kinda strange !!



--
--

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


"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote