I need to dts 150 files that have the same schema
and same file name except the date will be tagged on
the file. What is the best way to accomplish this task.
I thought about using an Active X Script that
would dynamically change the source name, and
use the data transformation task to move
over the data. Would this work or would the
transformations be fould up when the next
file gets processed

How about this

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

--
--

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

"Phil" <atec396 (AT) hotmail (DOT) com> wrote

It'll work. You just need to loop through the directory and
proceed with what you planned. Take a look at the following
example on sqldts.com:
http://www.sqldts.com/?246

-Sue

On Tue, 7 Oct 2003 11:14:10 -0700, "Phil"
<atec396 (AT) hotmail (DOT) com> wrote:

You could definatly use ActiveX, and there are many
examples of that posted, but BCP might be quicker if you
are dealing with a lot of data.