MS SQL's DTS supports various scripting languages that would be able to handle copying today's log to a standard file name that gets overwritten everyday. That way, the file name (and text datasource) can remain the same and the script handles the file name issues. We're doing something similar to that here using the PERL scripting extension to purge bad characters from a file before importing -- I think the regular install of MSSQL comes with an ActiveX scripting component. You just need to find someone who can write the script for you (unless, of course you know ActiveX or PERL).
Hope this helps. -- Kent Bulmer Application Developer BMG Consultants Inc. [EMAIL PROTECTED] pers: http://www.embers.org/ work: http://www.networkcentrix.com/ "...only visiting this planet..." (Larry Norman) FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
