Hello all,

Existing Server Environment:
Windows Server 2003 32 bit
SQL Server 2000

New Server Environment:
Windows Server 2008 64 bit Web Edition
SQL Server 2008 Web Edition

In the existing server environment the following asp script works fine:

const DTSSQLStgFlag_UseTrustedConnection = 256
set objDTSPackage = createObject("DTS.package")
objDTSPackage.loadFromSQLServer "zug\supplier", "", "",
DTSSQLStgFlag_UseTrustedConnection, "", "", "",
"RID9192-S3SDB-1-ASP_fullStocklistUpdate"
objDTSPackage.execute
objDTSPackage.unInitialize
set objDTSPackage = nothing

However when I attempt to run this in the new server environment I get the
following error on line 2:

"ActiveX compontent can't create object: DTS.package"

The SQL Server 2008 Management Studio has been set up to allow for the
design and execution of DTS packages - and I can in fact design and execute
the packages quite OK from within Management Studio. The problem occurs when
I try to run them from the web page.

Does anyone have any pointers for me? Is there a dll which ActiveX can't
see / access? Is it related to the fact this is now a 64bit environment?

Thanks in advance,

....naturally I use:

"server.createobject..." within the ASP page. Sorry - I cut this script
from a vbs console script which I am using to try and debug this problem.

"jcb" wrote: