I just tried to run this test DTS on my SQL7 server using code from
CFcomet...
The problem is, I get the error
COM error 0x800401F3. Invalid class string
I'm pretty new to using COM objects and was wondering if this was just
something stupid I needed to add, or what... ?
Marcus
><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"sql_server","sa","",0,"","","","import_dts","")>
> <CFCATCH>
> <CFSET error_message = "The DTS Package Could Not Be Loaded at this
time.">
> </CFCATCH>
></CFTRY>
>
><CFIF IsDefined("error_message")>
> <CFOUTPUT>#error_message#</CFOUTPUT>
></CFIF>
>
><CFSET p = objDTS.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
