> WOW!!, I haven't worked with DTS packages and not much with stored > procedures. I will do some research. You think that this is a better > solution then building a cf template and setup an automated task to run > the cf template (in order to process the csv file)? > Yes that will be much better. Much more efficient.
It'll save CF having to do lots of inserts into the database working its way through the file etc etc. Where as SQL server already has the functionality to import CSV files straight into a tables. Regards Stephen PS. If the CSV upload is done via a web-based CF admin, then I would trigger the scheduled task (for a quiet period) when the user uploads the file. ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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
