You can do this without creating a SP for that by using the SQL DMO objects
library and using <CFOBJECT>
I would recommend doing it in VB (or similar technology) first to get the
correct syntax and commands down, then convert to CF (or even write a DLL to
execute it, but that may be the same result as writing a Stored Procedure to
do it)
hth...
David L. Penton, MCP
Consultant
"Mathematics is music for the mind, and Music is Mathematics for the
Soul. - J.S. Bach"
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of [EMAIL PROTECTED]
Sent: Wednesday, February 07, 2001 2:17 PM
Is there a way to execute a local server DTS package from within
coldfusion? I already have the package created, I just want the user to be
able to execute the import from an administration screen. Or is the only
alternative to build a stored procedure to accomplish the same task?
Thanks for the input,
CC
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
