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
