I built a DTS package, which contains just one ActiveX Script Task
(VBScript).
In this script I have to create an object, used for crypting/decrypting
strings:
Set enobj=CreateObject("encrypt.encr")

This object is a DLL registered on the server.
I tested the script into an ASP page, it works fine. But in DTS it gives me
the following error:
"ActiveX component can't create object"

What is wrong with this object here? It works fine in other applications.
What have I do?

Please help. It's urgent!
Thanks.

In message <Obg8QjwGEHA.3472 (AT) TK2MSFTNGP11 (DOT) phx.gbl>, Mihaela M.
<mihaela.mesaros (AT) s-concept (DOT) net> writes
Are you sat at the server executing the package?

If you are sat at a workstation executing this package through
Enterprise Manager then that is where the package is executing, not the
server, so that is where the Dll needs to be registered. DTS is client
side, as it too is just a load of COM objects.


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Right! Few minutes ago I realized that. I was executing the DTS from
Enterprise Manager from another workstation, not from the server.
Then I realized it was wrong. I connected to the server with the Terminal
Client and I executed the DTS from there and it worked, of course

Thanks!!!


"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote