Hi
I have a directory that will have many input files (~10,000), all with
different names but following the same naming convention:

nITEMS.TXT

Where n is an alpha-numeric string of variable length; in other words, all
the filenames will all end with "ITEMS.TXT"

The structure of these files are identical and I wish to go through each
file in turn (order irrelevant) and import the data into my SQLServer
database. The transformation for each file's data will be identical.

If I were to do this for a single file, I'd use a text file source to point
to the text file and a DB connnection object and define the transformation.

What I guess I need to do is have some sort of ActiveX script that loops
through every file in the directory and for each file re-points the
text-file-source object to a different file and run the transformation. Not
sure how to achieve this....

Any suggestions?

Many thanks

Griff

This will do it for you

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


"GriffithsJ" <GriffithsJ_520 (AT) hotmail (DOT) com> wrote

It certainly appear to!

Many thanks

Griff