said you can use a sql command to run a dts package
Shawn
-----Original Message-----
From: Daniel O'Keefe [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 14, 2004 9:57 AM
To: CF-Talk
Subject: RE: DTS from SP
You have CF and SQL on the same box right? I do not. I am aware of the COM
method and might resort to that since it is an INTRANET only.
Dan
-----Original Message-----
From: Shawn Regan [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 14, 2004 12:06 PM
To: CF-Talk
Subject: RE: DTS from SP
no problem try this:
<CFTRY>
<CFOBJECT TYPE="COM" NAME="objDTS" CLASS="DTS.Package" ACTION=""> <CFCATCH TYPE = "Object">
<CFSET error_message = "The DTS Package Object Could Not Be
Created.">
</CFCATCH>
</CFTRY>
<CFTRY>
<CFSET r =
objDTS.LoadfromSQLServer("SQLSERVER","sa","password",0,"","","","DTSPackage"
,"")>
<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()>
This is what i use.
Shawn Regan
-----Original Message-----
From: Daniel O'Keefe [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 14, 2004 8:58 AM
To: CF-Talk
Subject: RE: DTS from SP
I want to run it on demand from a CFM page, hence my problem.
-----Original Message-----
From: Shawn Regan [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 14, 2004 9:49 AM
To: CF-Talk
Subject: RE: DTS from SP
Are you just trying to run a DTS package? If so you can use SQL Agent to run
it or you can run it from a cfm page.
Shawn Regan
-----Original Message-----
From: Dan O'Keefe [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 14, 2004 6:30 AM
To: CF-Talk
Subject: DTS from SP
I have combed the archives, and then net, and I think I have found the
info I need to be able to do this.
I used the DTSRUNUI to create this string:
'DTSRun /S "TESTDATA" /U "sa" /P "password" /N "frDay01_upload" /G
"{F96F01E6-D82C-4ECF-899E-7DDADB1976C6}" /W "0" '
When I run it from the DOS prompt, it works. When I try to run it with:
exec master..xp_cmdshell, both from QA and a SP, I get the following error:
DTSRun: Loading...
Error: -2147024629 (8007010B); Provider Error: 0 (0)
Error string: The directory name is invalid.
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 713
NULL
naturally the most frustrating part is trying to find out more info on
the error. I have looked in the mentioned .hlp file as well as MS &
google. Anybody have any ideas?
Dan
_____
_____
_____
_____
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
