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
Here's two stored procedures that will allow you to run a DTS package-it's
the method I use. You can call the SP from either CFQUERY or CFTOREDPROC
tags. The spExecuteDTS is the only SP you use, but the second SP is used by
spExecuteDTS.
-Dan
uot;sa","",0,"","","","test","")
CFCATCH
CFSET error_message = "The DTS Package Could Not Be Loaded
From the SQL Server at this time."
/cfcatch
/CFTRY
CFIF isDefined("error_message"
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
Do a search on this lists archives, you should find information on accessing
a dts as a com object.
http://www.mail-archive.com/cf-talk@houseoffusion.com/
Jeff Sarsoun
-Original Message-
From: Percy E Perez [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 16, 2001 1:14 PM
To: CF-Talk
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
See my detailed howto at:
http://forums.allaire.com/DevConf/Search_Results.cfm?#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 SQ
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
t;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
IL 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:
10 matches
Mail list logo