Search on DTS in "Database Access and Query Building"
Here's my attempt to copy it:
Date: January 06, 2001 05:21 PM
Author: Rick Moon ([EMAIL PROTECTED])
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
HTH,
Rick Moon
Attachments:
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>
At 08:17 PM 1/16/01 -0500, you wrote:
>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
