Sorry about that, I check the url against a cached copy I guess. Here's the
post:
Date: January 06, 2001 05:21 PM
Author: Rick Moon
Here's how I finally got it to work with SQL2000 and CF 4.51
Generate the values for the values above: 1) the DTSRun.exe needs to be on
your CF server running the cfm script manually or with scheduler. This
program is installed with SQL Tools, so you don't have to have SQL Server
intalled on this cfm machine.
2) cmd line or via windows explorer run DTSRunUI.exe
3) First select your db server and give the gui the username password, then
go to the top and click the "..." button to find your package. It won't work
the other way around.
4) You'll see the list of dts packages on that db server, select the one you
want and then okay.
5) click on advance
6) In the bottom where it says command line check encrypt and sql7.0 and
then generate.
7) in the grey box put in your cursor and select all of it
8) now past it into the arguments part of the your cf code
9) be sure to remove the DTSRun from what you copied, if you choose not to
encrypt, remove the "".
HTM,
Rick Moon
CFM code:
<cfexecute name="c:\program files\MicroSoft SQL
Server\80\Tools\Binn\DTSRun.exe"
arguments="/n name of server /u username /p password /n package description
/g packace UUID">
</cfexecute>
(http://forums.allaire.com/DevConf/Index.cfm?Message_ID=636447)
----- Original Message -----
From: "Bill Killillay" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, January 16, 2001 5:17 PM
Subject: RE: Running a MS SQL Server DTS Package from ColdFusion
> This link does not work. What can a person search on to get
> there?
>
> > -----Original Message-----
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, January 16, 2001 6:25 PM
> > To: CF-Talk
> > Subject: Re: Running a MS SQL Server DTS Package
> > from ColdFusion
> >
> >
> > See my detailed howto at:
> > http://forums.allaire.com/DevConf/Search_Results.c
> > fm?#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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
