Discussion:
executing DTS package from VBScript (ASP) with SQL Server 2008
(too old to reply)
jcb
2009-04-02 09:26:01 UTC
Permalink
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,
jcb
2009-04-02 09:56:01 UTC
Permalink
...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.
Post by jcb
Hello all,
Windows Server 2003 32 bit
SQL Server 2000
Windows Server 2008 64 bit Web Edition
SQL Server 2008 Web Edition
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
"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,
Loading...