You can also use a Stored Procedure that calls DTSRUN using xp_cmdshell.
This works well when CF and SQL are on separate machines.
Bob
-----Original Message-----
From: Daniel Daugherty [mailto:[EMAIL PROTECTED]]
Sent: April 24, 2001 10:49 AM
To: Fusebox
Subject: RE: Executing DTS Packages Via CF
In addition to using the COM solution listed in the article below you can
use <cfexecute> tag to run the SQL DTSrum command (check SQL books on line
for how to use DTSrun) or you can schedule the DTS package as a job and run
it with the stored procedure SP_startjob (see book on line for detail on
that SP).
The COM and Stored Procedure I like the best because they are easier to get
error detail back from than a dos command. Hope this helps.
Daniel D.
-----Original Message-----
From: Ken Wilson [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 9:26 PM
To: Fusebox
Subject: RE: Executing DTS Packages Via CF
How about this article titled "Execute SQL Server DTS packages from CF" by
Simon Horwith from Figleaf:
http://www.cfcomet.com/cfcomet/SQL_Server/index.cfm?ArticleID=A51CB8F7-C297-
4E80-92CC7A8907B0A5B2
Ken
-----Original Message-----
From: Marc Funaro [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 23, 2001 9:05 PM
To: Fusebox
Subject: OT: Executing DTS Packages Via CF
Sorry for the OT... feel free to respond directly to my email address to
keep the list happy...
I need to know if there's a way to execute DTS packages that reside on a
Microsoft SQL Server, using ColdFusion. If there is, can anyone point me to
some code examples?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
