I am having problems running a DTS package using the COM object from
CFCOMET...
I keep getting this error:
////////////////////////////////////////////////////////
No Steps have been defined for the transformation Package.
The error occurred while processing an element with a general identifier of
(CFSET), occupying document position (39:5) to (39:36).
///////////////////////////////////////////////////////
Here is my code:
********************************************************
<cftry>
<cfobject type="COM" name="AOlean_DTS" class="DTS.Package"
action="CREATE">
<cfcatch type="Object">
<cfset error = "There was a problem connecting to the DTS
engine on the SQL Server.">
</cfcatch>
</cftry>
<CFTRY>
<CFSET r =
AOlean_DTS.LoadFromSQLServer("SQL_Server_Name","sqlUN","sqlPass","","DTSpass
","C413BB2C-21DC-4E06-94B1-B3BA84C41D38","99263E03-5B93-4C53-A2D0-0B68510138
BE","AOlean_DTS","")>
<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 = AOlean_DTS.Execute()>
********************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
