hi

I have around abt 10 fixed width text files in a particular directory of the
hard drive . I want to automate the task of importing all these files into 1
table of SQL Server.

All the files have the same fields.

How do i do this.

Have a look at this article

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

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"aki_aki" <aki_aki (AT) discussions (DOT) microsoft.com> wrote