What I have done is to execute DTSrun using cfexecute.
Alternatively it is possible to execute dtsrun from within a storedproc in
SQL server...
It would also be possible and offer more control using a COM object, but I
dont know how to do that (if anyone does/has written one Id be
interested...)
If you are running Coldfusion under the system account, then the files to be
imported from all need to be on a local drive on the server - which is
awkward if you are not developing on the server itself, as effectively you
have to develop the package on the server...)
HTH, Dan
-----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
