I usually create a Visual Basic file out of the DTS package (one of the options when saving DTS packages) and then modifiy them directly from Visual Basic.
tom "Don Vawter" <[EMAIL PROTECTED]> wrote in message 01b601c1981b$67ae2710$6501a8c0@LAPTOP">news:01b601c1981b$67ae2710$6501a8c0@LAPTOP... > 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. ______________________________________________________________________ Get Your Own 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=coldfusionb 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

