In most cases yes an SP will do, but DTS can be pretty complex and any large recordset manipulation should be done in the SQL server as ColdFusion is poor at large recordset processing.
"This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -----Original Message----- From: Munson, Jacob <[EMAIL PROTECTED]> To: CF-Talk <cf-talk@houseoffusion.com> Sent: Tue Jul 25 19:36:12 2006 Subject: RE: execute a DTS package via Stored Proc? I know I'm probably barking up the wrong tree, but you could always /not/ use a DTS package. I know a lot of the stuff that DTS does can be done using stored procedures, or other fancy tricks. But it all depends on how complicated your DTS is. > -----Original Message----- > From: Ray Champagne [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 25, 2006 8:27 AM > > Cool...I'll check yours out first. > > Now, of course, I'm off to fight fires that always pop up at > the worst > possible times. Grrr... > > Snake wrote: > > Well the way I did worked for restricted user access. Where > the user is DBO > > of his own database and nothing else. This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247650 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4