Steven, There are a couple of ways to do this. The first using CFObject is outlined on cfcomet.com. Antoher way is to run DTS using cfexecute as follows.
<CFSET sArg = "/S servername /U username /P password /N packagename"> <CFEXECUTE name="c:\program files\microsoft sql server\80\tools\binn\dtsrun.exe" arguments="#sArg#" outputfile="c:\MyExportLog.txt" timeout="1800"/> HTH, Dave -----Original Message----- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: 10 May 2002 15:12 To: CF-Talk Subject: executing sql server dts package from cf I've never done this. Where can I find information? Thanks, Steven D Dworman Macromedia Certified Developer --------------------------------------------------------- Web Consultant Systems Administrator ComSpec International - http://www.comspecinternational.com phone: 248.647.8841 cell: 248.767.9925 --------------------------------------------------------- EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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
