Hi, I need to import to a data base from various text file using the DTS.
The files are in the same folder (for example: C:\TEMP\)
How can I do that?


Best Regards,

Jooão Correia

Same structure, same table ????
Are you looking for something that loops or help in creating a package that
imports a text file?

Here you go for both


Building a Package in the DTS Designer
(http://www.sqldts.com/default.aspx?278)

Looping, Importing and Archiving
(http://www.sqldts.com/default.aspx?246)

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
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


"Jo?o COrreia" <j_p_correia (AT) hotmail (DOT) com> wrote