may be oversimplifed but... <cfexecute name="c:\path\to\DTSRun.exe" arguments="-S ServerName -E -N DTSName"/>
load the page and boom, executed DTS Package. I'm sure one could set up a switch/case scenario as well. Or one of the other methods. will ---- William H. Bowen Webmaster ALSTOM's Energy Management and Markets Business [EMAIL PROTECTED] http://www.esca.com/ 425.739.3629 Voice 425.466.7016 Cell 425.739.3690 FAX Master ColdFusion 4.5 - Brainbench 10/02/2001 http://www.brainbench.com/transcript.jsp?pid=1577915 ---- CONFIDENTIALITY: This e-mail and any attachments are confidential and may be privileged. If you are not a named recipient, please notify the sender immediately and do not disclose the contents to another person, use it for any purpose or store or copy the information in any medium. ----- Original Message ----- From: "Richard Colman" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, November 16, 2001 11:32 AM Subject: SQL-Server DTS through CF > I would like to be able to import an ACCESS data table into SQL-Server > 2000 (using DTS?), and do a reverse export, under CF control. This needs > to happen every month. Does anyone know of any documentation or sample > code for this kind of task? Any pointers would be much appreciated. > > Thank you. > > Rick Colman > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
