Managing Multiple Excel incoming files?


I have this situation. I have a client which have several locations they
work primary with excel forms and they are thinking in doing reports with
them. What they want is to import those Excel files into SQL Server for
later using crystal reports or maybe asp.net for reporting. Those files
will come every week from diferent locations then go to SQL Server and then
they should be stored in a folder in the server for backup. So this means
that i have to deal with the importing but also with the file naming. This
is because they want the reports to be date based. So i have to ask them to
include the date as part of the file name or changing the file name after
procesing the file if I want to store them all in the same folder after
procesing.

So the real question is how do I deal with multiple file in regular basis
bye changing the name of the file or enforcing they send me the file with
the date already included. If the recomendation is the second one how can i
tell the system to change the files after the procesing?

Is there any easy way or tool to achive this? is there any way i can
configure DTS to do that?


Eliezer

In message <Xns9479AC80857B4efigueroapropointcom (AT) 216 (DOT) 196.97.132>,
Eliezer Figueroa <efigueroa (AT) propoint (DOT) com.do> writes

You can derive filenames based on dates, and change connections all
through ActiveX Script, e.g.

How can I change the filename for a text file connection?
(http://www.sqldts.com/default.aspx?200)

You can also manage files through script-

Working with files and the FileSystemObject
(http://www.sqldts.com/default.aspx?292)
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Thaks a lot . Great Site !

Eliezer