Shoot me if I'm wrong, but.... I'm pretty sure DTS is based on vb-script (or can be). If that's the case then you can instantiate a File system object, and use it to retrieve your directory listing. You might need to convert the directory listing to an array, but you could then step through the listing, open each file listed, process it, close it, move onto the next file.
Could be wrong of course, cuz I haven't worked much with DTS much , but my coworkers have, and suggested that this should be possible. And of course, now that you have a solution in CF, you probably don't need to get this working from pure DTS. My two cents worth. Shawn Grover -----Original Message----- From: Don Vawter [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 3:59 PM To: CF-Talk Subject: Re: OT Modifying Source File in DTS package 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
