hai,

I have DTS package, It work in Localhost.
But when executing via ASP.NET from Webserver, I
have the following error.

Exception Details: System.Exception: Cannot create ActiveX
component.

my code is

Dim objPack
Const DTSSQLStgFlag_Default = 0
objPack = Createobject("DTS.Package")

Thanks in Advance.

with regards,
Prakash.

It looks like you have not got the DTS dlls registered on the PC that says
"Execute"

Redistributing DTS with your program
(http://www.sqldts.com/default.aspx?225)

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Prakash" <dharmaprakash (AT) prudencetech (DOT) com> wrote

what should i do for execute the DTS pacakge?
If I should distribute, how can i do it?
I have ftp username and pwd.

Please Explain me....

Thanks in advance.,

With regards,
Prakash.

There is no problem using DTS from ASP it is simply that DTS is client side
so if you execute it on any box then they need to have the DLLs registered.
They also require permissions to do whatever it is the package does.

Execute a package from Active Server Pages (ASP)
(http://www.sqldts.com/default.aspx?207)

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Prakash" <dharmaprakash (AT) prudencetech (DOT) com> wrote