WAY OT DTS PACKAGE
Does anyone know via DTS how to open a zip file so that I can attach to a dbf file that is in the zip file? Josh __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: WAY OT DTS PACKAGE
>From within the DTS Designer choose the Execute Process Task, and run an unzip program on your zip. jon - Original Message - From: "Joshua Tipton" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, May 16, 2002 10:18 AM Subject: WAY OT DTS PACKAGE > Does anyone know via DTS how to open a zip file so that I can attach to a > dbf file that is in the zip file? > > Josh > > __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: WAY OT DTS PACKAGE
SQL 2000's DTS package allows you to run any Win32 process or batch file via a "Execute Process Task". You can use this to run the unzip program before you import the data. I don't think this is available for SQL 7. --- Joshua Tipton <[EMAIL PROTECTED]> wrote: > Does anyone know via DTS how to open a zip file so > that I can attach to a > dbf file that is in the zip file? > > Josh > > = I-Lin Kuo Macromedia CF5 Advanced Developer Sun Certified Java 2 Programmer __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists