See my detailed howto at:
http://forums.allaire.com/DevConf/Search_Results.cfm?#Message636447
Rick
----- Original Message -----
From: "JustinMacCarthy" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, January 16, 2001 12:49 PM
Subject: RE: Running a MS SQL Server DTS Package from ColdFusion
> 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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
