I decided to do it in cf. There are some advantages that way. I do a little cleaning on the front end to eleminate the garbage requests from code red and to exclude entries from internal hits and scheduled tasks. What I do is scan the directory, grab a file, clean it , append into db, rename the file so that it won't be included again. I have it set up to handle multiple websites in multiple directories going into multiple databases and it seems to work fine. I still handle a lot of the processing via an insert trigger in the db.
----- Original Message ----- From: "Eric Dawson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, January 09, 2002 3:50 PM Subject: Re: OT Modifying Source File in DTS package > makes sense. I wanted to something like this a little while back. > > for web logfiles - I wanted to get something that would scan a directory for > new files. update a log, and import and process files that haven't yet been > imported. > > It wasn't too bulky so I just manually imported and processed the files, but > something like this should be able to be done relatively easy. I have done > similar things in Access (scan directory and import all the files in the > directory). But I didn't spend any time to get MSDE to work for me with DTS. > > so any insight is appreciated. > > Eric > > > From: Nick McClure <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > To: CF-Talk <[EMAIL PROTECTED]> > Subject: Re: OT Modifying Source File in DTS package > Date: Tue, 08 Jan 2002 22:49:14 -0500 > > You are probably correct. > > Unfortunately to the best of my knowledge there is no way to change the > input filename. I have run into this before. > > One of the things you can as part of the DTS is run a batch file, use the > Execute Process task. > > I would create a batch file that would make a copy of the file with name > you have selected for your input tasks. > > At the end of the DTS delete the copy. > > I have done this before with both text files and Excel spread sheets. It > works pretty well as long as you have the disk space to hold the copy. > > At 08:31 PM 1/8/2002 -0700, you wrote: > >All I want to do is import the log files daily and the name of the logfile > >changes every day. > >Right now I am just handling it in CF instead of using DTS but it seems > like > >DTS would be a more efficient way. > > > >----- Original Message ----- > >From: "Nick McClure" <[EMAIL PROTECTED]> > >To: "CF-Talk" <[EMAIL PROTECTED]> > >Sent: Tuesday, January 08, 2002 8:23 PM > >Subject: Re: OT Modifying Source File in DTS package > > > > > > > You want to change the source file of the DTS or of a CFM? > > > > > > The DTS source is typically stored on the DB inside the MSDB database, > and > > > > > > is not easy to get to, in fact, I have never actually found all of it. > If > >I > > > > > > remember correctly it is stored in a binary column, which would be very > > > difficult to edit. > > > > > > Can you give me some more info? > > > > > > At 01:06 AM 1/8/2002 -0700, you wrote: > > > >I have a DTS package which I use to import IIS log files into SQL > Server > > > >2000. > > > >How can I change the source file programaticallly and then run > > > >the package. I really am a newbie at DTS but I guess you can tell > that. > > > > > > > >I know that I could always do the import with cf but it seems kind of > >silly > > > >to involve cf for a purely database function. > > > > > > > >TIA > > > > > > > >Don > > > > > > > > > > > > > > > > > > > > > > > ______________________________________________________________________ Why Share? Dedicated Win 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=coldfusionc 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
