maybe not the fix you were looking for...but you could execute it from CF. www.cfcomet.com has an article by Simon Horwith that steps through this method...
http://www.cfcomet.com/cfcomet/SQL_Server/index.cfm?ArticleID=A51CB8F7-C297- 4E80-92CC7A8907B0A5B2 -----Original Message----- From: Steven Dworman [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 3:15 PM To: CF-Talk Subject: executing a dts package Here's the deal. We have a DTS package that needs to be executed on a monthly basis. The problem is that SQL server 7 can't execute it. It fails every time. If we run the package manually it works just fine. Any ideas? Thanks, Steven D Dworman --------------------------------------------------------- Web Consultant Systems Administrator ComSpec International - http://www.comspec-intnl.com phone: 248.647.8841 cell: 734.972.9676 --------------------------------------------------------- EMPOWER-XL ***Software for Higher Education*** http://www.empower-xl.com ______________________________________________________________________ Get Your Own 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=coldfusionb 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