options:
use cfexeccute and rundts
use xp_cmdshell
create a job & run it
or you can run that code using cfobject
as per the MS example
<cfset DTSReposFlag_Default = 0>
<cfset DTSReposFlag_UseTrustedConnection = 256>
<CFOBJECT ACTION="Create" TYPE="COM" CLASS=DTS.Package
NAME="oPackage">
<cfset oPackage.LoadFromSQLServer
('servername','','',256,'','','','MyPackage','')>
<cfset oPackage.Execute()>
Justin
>-----Original Message-----
>From: Percy E Perez [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, January 16, 2001 6:14 PM
>To: CF-Talk
>Subject: Running a MS SQL Server DTS Package from ColdFusion
>
>
>Anyone has any suggestions on how to run a DTS package from a coldfusion
>page?
>I found article# Q252987 on technet on how to do this using ASP, but I
>would rather implemented in ColdFusion. Thank you for any suggestions.
>
>
>Percy E Perez
>
>
>> -----Original Message-----
>> From: Clint Tredway [mailto:[EMAIL PROTECTED]]
>> Sent: Tuesday, January 16, 2001 11:59 AM
>> To: CF-Talk
>> Subject: RE: SQL Manager
>>
>>
>> Yep, this will be taken care of soon.
>>
>> -----Original Message-----
>> From: Neil Clark [mailto:[EMAIL PROTECTED]]
>> Sent: Tuesday, January 16, 2001 10:44 AM
>> To: CF-Talk
>> Subject: RE: SQL Manager
>>
>>
>> yep, I would NEVER want anyone connecting to the Master DB.
>> I always keep
>> my SQL Servers on the inside of the firewall allowing no
>> access from the
>> outside world - only from the cf server.
>>
>> Neil
>>
>> <! -----------------------------------
>> Neil Clark
>> Senior Web Applications Engineer
>> ColdFusion / Spectra / XML
>> mcb digital [Allaire Premier Partner]
>> Tel. +44 (0)20 8941 3232
>> Tel. +44 (0)20 8408 8131 [Direct]
>> http://www.mcbdigital.com
>> ----------------------------------->
>>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
