very easy to run DTS from CF.
here is an e.g.
<cfquery name="DTSImport" datasource="#DSN#">
master.dbo.xp_cmdshell 'DTSRun /~S
0x570181FD8A97DA72994BA30CD26A73E4C23626D16140CF0 /~U 0xF8141F8065D98248 /~P
0x23CAD6B1F4C4A4FBA499C068C0851BA3F2B320313D854C83 /~N
0x8633C5F800EA5FB74BA6756A1A7C499E0BECB133550E554589B918A33667AFE11A2A97320E
29F6FC8431DEF154CA67B '
</cfquery>
U can find the hexadecimal encrypted sting by scheduling the DTS then go in
to the Job, under SQL SEM, Management, Jobs, Properties, Steps, Edit the
step that runs your DTS it will have the command u need to run (the command
will look like this DTSRun /~S
0x5701181D8A97DA72994BA30CD26A73E4C23626D16140CF0 /~N
0x5AEDF53AEB844805D84A0F5C167B98D34FDD2EBBCC75CAF55AFED3C357DA785DD056F835CB
5B36BB365A3B921227B99 /E ).
>From Rif
-----Original Message-----
From: Percy E Perez [mailto:[EMAIL PROTECTED]]
Sent: 16 January 2001 18:14
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
