Hello All,

Sorry I didn't get back to you as fast as I wanted to, but I got in late last night and found myself with things that had to be...

Everyone,

Thank you all very much!  I am heading out for a cup of coffee and then some chores, but I will take my laptop with me and make a point...

Hi Jeff Moden,

1. Here is a printout of the first 10 records (rows) of one of the files:

<TICKER>,<PER>,<DTYYYYMMDD>,<TIME>,<OPEN>,<HIGH>,<LOW>,<CLOSE>,<VOL>,<OPENINT>

AAC,D,19990721,000000,2.4100,3.5500,2.4000,3.5500,14602,0

AAC,D,19990722,000000,3.5000,4.4000,3.4000,4.3500,12531,0

AAC,D,19990723,000000,4.4000,5.1500,4.3200,5.0000,7517,0

AAC,D,19990726,000000,15.0000,16.0000,6.5000,9.0000,897,0

AAC,D,19990727,000000,10.5000,11.5000,6.0000,8.0000,671,0

AAC,D,19990728,000000,8.5000,8.5000,5.5000,6.0000,252,0

AAC,D,19990729,000000,6.0000,6.0000,4.2500,4.7500,670,0

AAC,D,19990730,000000,5.2500,5.2500,4.5000,4.5000,638,0

AAC,D,19990802,000000,5.0000,7.6000,4.6300,4.6300,102,0

2. Actually, I created the table StockData on my laptop computer, and ---...

Lowell, Jeff Moden, Jeff Gray,

Before anything else, I want to thank you all for your very interesting and helpful ideas!

As a newbie, I feel a little overwhelmed.  As a result, I...

Would I be creating some logic for the Bulk Insert command from within Query Analyzer, or is there some way to access the Bulk Insert from within DTS?

Please forgive my...