RE: Running a MS SQL Server DTS Package from ColdFusion
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 0x8633C5F800EA5FB74BA6756A1A7C499E0BECB133550E554589B918A33667AFE11A2A97320E 29F6FC8431DEF154CA67B ' /cfquery U can find the hexadecimal encrypted sting by scheduling the DTS then go in to the Job, under SQL SEM, Management, Jobs, Properties, Steps, Edit the step that runs your DTS it will have the command u need to run (the command will look like this DTSRun /~S 0x5701181D8A97DA72994BA30CD26A73E4C23626D16140CF0 /~N 0x5AEDF53AEB844805D84A0F5C167B98D34FDD2EBBCC75CAF55AFED3C357DA785DD056F835CB 5B36BB365A3B921227B99 /E ). From Rif -Original Message- From: Percy E Perez [mailto:[EMAIL PROTECTED]] Sent: 16 January 2001 18:14 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
RE: Running a MS SQL Server DTS Package from ColdFusion
BEGIN
PRINT '*** Unable to get ExecutionResult'
EXEC sp_displayoaerrorinfo @Step , @hr
RETURN 1
END
EXEC @hr = sp_OAGetProperty @Step, 'Name', @StepName OUTPUT
IF @hr 0
BEGIN
PRINT '*** Unable to get step Name'
EXEC sp_displayoaerrorinfo @Step , @hr
RETURN 1
END
EXEC @hr = sp_OAGetProperty @Step, 'Description', @StepDescription
OUTPUT
IF @hr 0
BEGIN
PRINT '*** Unable to get step Description'
EXEC sp_displayoaerrorinfo @Step , @hr
RETURN 1
END
INSERT #PkgResult VALUES(@StepName, @StepDescription, @StepResult)
PRINT 'Step ' + @StepName + ' (' + @StepDescription + ') ' + CASE WHEN
@StepResult = 0 THEN 'Succeeded' ELSE 'Failed' END
SELECT @StepCount = @StepCount - 1
SELECT @oPkgResult = @oPkgResult + @StepResult
END
SELECT * FROM #PkgResult
IF @oPkgResult 0
BEGIN
PRINT 'Package had ' + CAST(@oPkgResult as varchar) + ' failed step(s)'
RETURN 9
END
ELSE
BEGIN
PRINT 'Packge Succeeded'
RETURN 0
END
-Original Message-
From: Percy E Perez [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 16, 2001 1: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
~~
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
FW: Running a MS SQL Server DTS Package from ColdFusion
-Original Message-
From: JustinMacCarthy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 16, 2001 8:50 PM
To: [EMAIL PROTECTED]
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
RE: Running a MS SQL Server DTS Package from ColdFusion
Default Syntax to Create DTS Object:
cfobject type="COM" name="myObjectName" class="DTS.Package"
action="CREATE"
There are 3 primary locations DTS packages are generally loaded from: from
SQL Server, from Storage File, or from repository. There are 3 different
primary methods that can be executed, one for each of these DTS locations.
LoadFromSQLServer Syntax:
ObjectName.LoadFromSQLServer("ServerName",
"ServerUserName",
"ServerPassword",
"Flags",
"PackagePassword",
"PackageGuid",
"PackageVersionGuid",
"PackageName",
"pVarPersistStgOfHost")
NOTE: if you want to retrieve the PackageGuid, PackageVersionGuid,
PackageName from the database, run the sp_enum_dtspackages system stored
procedure.
it returns the following variables: name, id, versionid, description,
createdate, owner, size, packagedata, isowner
LoadFromStorageFile Syntax:
ObjectName.LoadFromStorageFile("UNCFile",
"Password",
"PackageID",
"VersionID",
"Name",
"pVarPersistStgOfHost")
LoadFromRepository Syntax:
ObjectName.LoadFromRepository("RepositoryServerName",
"RepositoryDatabaseName",
"RepositoryUserName,
"RepositoryUserPassword,
"PackageID,
"VersionID,
"PackageName,
"Flags",
"pVarPersistStgOfHost")
This is sample code to execute a (SQLServer) DTS from ColdFusion ("objDTS"
is the Object I created, server is "shorwith", username is "sa" with no
password, "test" is the name of the DTS):
CFTRY
cfobject type="COM" name="objDTS" class="DTS.Package"
action="CREATE"
cfcatch type="Object"
CFSET error_message = "The DTS Package Object Could Not Be
Created"
/cfcatch
/CFTRY
CFTRY
CFSET r =
objDTS.LoadfromSQLServer("SHORWITH","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")
cfoutput #error_message# /cfoutput
/cfif
CFSET p= objDTS.Execute()
~Simon
Simon Horwith
Allaire Certified ColdFusion Instructor
Certified ColdFusion Developer
Fig Leaf Software
1400 16th St NW, # 220
Washington DC 20036
202.797.6570 (direct line)
www.figleaf.com
-Original Message-
From: Rif Kiamil [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 17, 2001 9:33 AM
To: CF-Talk
Subject: RE: Running a MS SQL Server DTS Package from ColdFusion
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
0x8633C5F800EA5FB74BA6756A1A7C499E0BECB133550E554589B918A33667AFE11A2A97320E
29F6FC8431DEF154CA67B '
/cfquery
U can find the hexadecimal encrypted sting by scheduling the DTS then go in
to the Job, under SQL SEM, Management, Jobs, Properties, Steps, Edit the
step that runs your DTS it will have the command u need to run (the command
will look like this DTSRun /~S
0x5701181D8A97DA72994BA30CD26A73E4C23626D16140CF0 /~N
0x5AEDF53AEB844805D84A0F5C167B98D34FDD2EBBCC75CAF55AFED3C357DA785DD056F835CB
5B36BB365A3B921227B99 /E ).
From Rif
-Original Message-
From: Percy E Perez [mailto:[EMAIL PROTECTED]]
Sent: 16 January 2001 18:14
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
! --
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
RE: Running a MS SQL Server DTS Package from ColdFusion
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 interested...) If you are running Coldfusion under the system account, then the files to be imported from all need to be on a local drive on the server - which is awkward if you are not developing on the server itself, as effectively you have to develop the package on the server...) HTH, Dan -Original Message- From: Percy E Perez [mailto:[EMAIL PROTECTED]] Sent: 16 January 2001 18:14 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
RE: Running a MS SQL Server DTS Package from ColdFusion
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 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
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
Re: Running a MS SQL Server DTS Package from ColdFusion
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 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
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
RE: Running a MS SQL Server DTS Package from ColdFusion
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
Re: Running a MS SQL Server DTS Package from ColdFusion
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
