If the mods are simple (verifying a numeric value or a particular format - or a date), then use the DTS transformation services and vb to massage the data during the import. The way I do it is to create the package and save it, then go to design view. The "transformation" connections all say "copy" at this point. Delete the connections that you want to fiddle with, the select "new active X transformation". The interface makes it pretty easy - with common functions listed to the left of the scripting window.
Mark -----Original Message----- From: Don Vawter [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 12:07 AM To: CF-Talk Subject: OT Modifying Source File in DTS package 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 ______________________________________________________________________ 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=coldfusiona 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
