fwiw, I've had this in my snippets for awhile...never used it though.
<cfoutput>
<cftry>
<cfobject
type = "COM"
name = "oDTS"
class = "DTS.Package"
action = "CREATE">
<cfcatch type = "Object">
<cfset errmessage = "The DTS Package Object Could Not Be
Created.">
</cfcatch>
</cftry>
<cftry>
<cfset dummy =
odts.loadfromsqlserver("ServerName","LoginName","LoginPassword",0,"","","","PackageName","")>
<cfcatch>
<cfset error_message = "The DTS Package Could Not Be Loaded
From the SQL Server at this time.">
</cfcatch>
</cftry>
<cfif isdefined("errMessage")>
#errMessage#
<cfelse>
<cfset dummy = #odts.execute()#>
</cfif>
</cfoutput>
--
jon
mailto:[EMAIL PROTECTED]
Wednesday, August 13, 2003, 9:24:21 AM, you wrote:
LCL> talking about DTS packages, is there a way to run a DTS package from CF?
LCL> larry
>>MS DTS packages using odbc should work nice
>>----- Original Message -----
>>From: "Todd" <[EMAIL PROTECTED]>
>>To: "CF-Community" <[EMAIL PROTECTED]>
>>Sent: Wednesday, August 13, 2003 12:25 AM
>>Subject: Database tech question
>>
>>
>>> I've come across a Sybase ASA 7 database that I need to get running. I
>>> don't have a Sybase engine. Does anyone know of anything I can use to
>>> convert the Sybase database to an SQL Server database?
>>>
>>> Todd
>>>
>>>
>>
LCL>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=5
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community.
http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
