Hello all,

I have been using the following code with MX 6.1 and MDAC 2.6 RTM. ( I did not
create this. Found it on the web)

<cfset s = "servername" >
<cfset u = "username" >
<cfset p = "password" >
<cfset n = "DTSPackageName" >
<cfset c = "0" >
<cfset null = "" >

<cfobject action="Create" type="COM" class="DTS.Package2" name="objDTSPackage">
<cfset objDTSPackage.LoadFromSQLServer(s,u,p,c,null,null, null,n,null) >
<cfset objDTSPackage.FailOnError = "True" >
<cfset objDTSPackage.Execute() >

This code causes CF 7 to crash. It will also fail (AutomationException:
0x8007007e) in CF MX 6.1 with any version of later than MDAC 2.6 RTM. Since
CF 7 requires MDAC 2.6 SP2 or later I am stuck. I know there are other ways to
use DTS, but I would like to understand why this stopped working.

Because of the 0x8007007e error, I verified that the DTSPKG.DLL had been
registered with regsvr32.

Anyone else having this problem? Any known solutions?