hello,

i am trying to do the following:

i have a folder full of text files. each text file
contains a list of records. each record represents one
day of price/volume data for a stock (date, open, high,
low, close, up volume, down volume). each text file is a
set of records for one stock -- the stock symbol is not in
the body of the text file. instead it is included in the
name of the file: <ticker symbol>.txt

i need to:

loop through all these files:
1) figure out what ticker the data is for,

2) retrieve the appropriate StockID for that ticker,

3) perform some minor transformations on the data
(e.g. add the up volume and down volume columns into one
total column),

4) write the data to my historical price table in the
database.

any suggestions as to the best way to go about this?

i've started to look at DTS but am feeling like i will
have to learn a bunch (vbscript, dts object model maybe)
and am feeling overwhelmed -- if that is the best way to
do it though, then i will.

much thanks!

matt

OK

Minor adjustments to this article.

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


You can perform a lookup in an ExecuteSQL task that returns to a Global
Variable the value of the StockID from the partial text file name.
You pass this into a Global Variable and you can then use it in any ActiveX
transform in the package.




--
--

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

"matthew c. harad" <mharad (AT) artoriusfunds (DOT) com> wrote

re: your reply.

thank you for the complete answer. i checked out your
site and it looks cool. for now i have wimped out and
written a few procedures in vba which work ok. i may
reimplement it in dts later.

appreciated,
matthew