I've read several posts out here and am at least finding some answers,
but I'm new to DTS and am looking for some advice.

I'm building a web app that will allow clients to upload Excel files
ranging anywhere from 15000 to 30000 rows. This data then needs to be
stored in a SQL Server 2k table (all client data will be in the same
table, uniquely identified by clientID, submission date, and some row
identifier - and these are not in the excel files). So can DTS allow
me to insert new rows in a SQL table and add info to those rows?

I will be using asp.net with vb.net. Originally, I thought about
reading the excel file and populating a dataset to push down to SQL
server, but we're talking lots of hits on the db server, so someone
mentioned DTS to me.

The system needs to be real time and automatic - no batches, no manual
intervention. With this in mind, is DTS the way I want to go?
Advice? Resources? I'm googled out with searching, so I thought it
time to come to the experts!

Thanks in advance!
BTG

DTS will do the Excel Thing
Real Time - No.


--

----------------------------
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



"BTG" <btgconsult (AT) yahoo (DOT) com> wrote