>-----Original Message-----
>From: JustinMacCarthy [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, January 16, 2001 8:50 PM
>To: [EMAIL PROTECTED]
>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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
