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
