RE: Running a MS SQL Server DTS Package from ColdFusion

2001-01-17 Thread Rif Kiamil
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

RE: Running a MS SQL Server DTS Package from ColdFusion

2001-01-17 Thread Dan G. Switzer, II
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

RE: Running a MS SQL Server DTS Package from ColdFusion

2001-01-17 Thread Simon Horwith
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"

RE: Running a MS SQL Server DTS Package from ColdFusion

2001-01-16 Thread Daniel Lancelot
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

RE: Running a MS SQL Server DTS Package from ColdFusion

2001-01-16 Thread Jeff Sarsoun
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

RE: Running a MS SQL Server DTS Package from ColdFusion

2001-01-16 Thread JustinMacCarthy
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

Re: Running a MS SQL Server DTS Package from ColdFusion

2001-01-16 Thread moonerent
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

RE: Running a MS SQL Server DTS Package from ColdFusion

2001-01-16 Thread Bill Killillay
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

RE: Running a MS SQL Server DTS Package from ColdFusion

2001-01-16 Thread paul smith
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

Re: Running a MS SQL Server DTS Package from ColdFusion

2001-01-16 Thread moonerent
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: