thanks fellas. you've helped out a bunch. -----Original Message----- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 10:27 AM To: CF-Talk Subject: RE: executing sql server dts package from cf
you can also create an SP that executes your DTS package, then call the SP from CF with CFQUERY. that's what we do here, since i've had mixed results instantiating a COM object as CFCOMET recommends. christopher olive cto, vp of web development, vp it security atnet solutions, inc. 410.931.4092 http://www.atnetsolutions.com -----Original Message----- From: Dave Wilson [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 10:07 AM To: CF-Talk Subject: RE: executing sql server dts package from cf 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 ______________________________________________________________________ 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
